AD 87-10-06 R1
Registered aircraft · 72,010
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N952ANAztec 66 LLC · Indianapolis, INN952DAEppes Michael Scott · Austin, TXN952DGSkywatch Aviation LLC · Leesburg, VAN952JCCarver Jonathan E · Oxford, NCN952LCThorx Aviation LLC · Tampa, FLN952MKhan Mohsin H · Lodi, CAN952NDUniversity Of North Dakota · Grand Forks, NDN952SHNelson Chris · Crown Point, INN952TBLong Jacob · Bend, ORN952TFAir Fleet Holdings LLC · Missoula, MTN952WAMcenery William J · East Haddam, CTN95302Wright David W · Arlington, TXN95303Morrison Robert F II · Denton, TXN95305Eagle Aviation Inc · Tucson, AZFirst renewal noticeN9530BSierra Alpha Aeronautical LLC · San Antonio, TXN9530JNations Jeffrey L · Kingshill, VIN9530LClark Dale H · Discovery Bay, CAN9530WGateway Flight Training LLC · Saint Louis, MON95315Valencic Adam · Apopka, FLN9531DAtp Aircraft 4 LLC · Wilmington, DEN9531JGrayhawk Flight Training LLC · Lucas, TXN9531KCline Timothy E · Rome, GAN9531LBaker Bob E · Carmichael, CAN9531MWright Bradley S · Quitaque, TXN95327Seashell Aviation LLC · Milton, FLN95329Jay Stylz Trucking LLC · Cedar Rapids, IAN9532DPayne Frederick B · Fayetteville, GAN9532JHarris Jason L · Clanton, ALFirst renewal noticeN9532LShattuck Charles W · Goshen, CTN9532PAerial Banners North Inc · Pembroke Pines, FLN9532WRodriguez Santos Jr · West Plains, MON9533GSmith James R · Delaware, NJN9533JWadel Ronald A · Shippensburg, PAN9533MHattensty Robert Wade · Burleson, TXN95343Obert Megan E · Hartselle, ALN95346Jackson Douglas A · Cynthiana, KYN95347Jora Imports LLC · Atlanta, GAN9534DLevinson Isaac F · White Salmon, WAN9534HBotezatu Florin · Gig Harbor, WAN9534JTock Robert · Saint Paul, MON9534LPowley Robert L · Mahwah, NJN95357Kidd Keith W · Covington, KYN9535HNorthwest Wings LLC · Hillsboro, ORN9535JBradley D Schnell · Mequon, WIN9535MGillman Charles J · Houston, TXN9535WEast Carolina Aviation LLC · Camden, NCN95364Hostetler Joseph A · Brownsburg, INN95365Mason Brent M · Clarksville, FLN95369Szmurlo Steven R · Easton, PAN9536DCalifornia Management And Consulting LLC · North Hollywood, CA
Back to AD 87-10-06 R1