AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N9295TViking Custom Builders Inc · Anchorage, AKN9296BColby Robert D · Bigfork, MTN9296CDinstel Delbert F · Park City, MTN9296GGreen Daniel C · Cedar Hill, TNN9296HSmith Richard A · Burnsville, MNN9296XJasuma Farms · Maxwell, CAN9297TSutton Aircraft Salvage LLC · Palmer, AKN9297UNorthwest Wings LLC · Hillsboro, ORN9297XJohnson Durwood D · Beaumont, TXN9298AHenderson Larry V · Highland Village, TXN9298GA&A Aviation LLC · Mountain Brk, ALN9298ZFrederick Ag LLC · Humboldt, KSN92995Yoanna Flight School Inc · Fort Myers, FLN929AEColman Steve · Alamosa, CON929BMSuntops Aircraft Holding LLC · Lakeland, FLN929FRacoon Aviation LLC · San Antonio, TXN929LSFlying Tigers Flight School Ltd · Houston, TXN929PMRegistered aircraftN929RHJohnson Merlin K Trustee · Mentone, CAN92ATBroquet Bruce L · Anchorage, AKN92BMNugent James S · Diamondville, WYN92CRodriguez Michael C · Drums, PAN92CCCanadian Co Sheriffs Office · El Reno, OKN92CKKingsborough James D · Carlisle, PAN92CMN92cm LLC · Genola, UTN92CPSlattery Richard E · Fountain Valley, CAN92DCAdams Bob L · Eagle River, AKN92DSBooty Bill · Idaho Falls, IDN92DWBurnette Jeffrey T · Big Lake, AKN92FRGliem Robert E Jr · Eddystone, PAN92GDStefenelli Aviation N-Tr Inc Trustee · AtterseeFirst renewal noticeN92MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN92MSCil N92ms LLC · Mcallen, TXN92NAOneill Laurie A · Pinckney, MIN92RHCrabtree Nathan J · Boise City, OKN92RZSale Reported · Gold Canyon, AZSale reportedN92SCMorrison Neil E · Port Townsend, WAN92WMGerhardt David C · Denver, CON93002Lcc North LLC · Freehold, NJN9300BBenson Ryan Denson · New Carlisle, OHN9300NChristensen Hans · Enterprise, UTN9300XEdwards Karen Marie · Mcminnville, ORN93010Davis Russell C · Odessa, TXN93018Joy Austin J Jr · Anchorage, AKN9301BGimli Son LLC · Fort Lauderdale, FLN9301ERyan Aircraft Holding LLC · Orlando, FLN9301XShaunkoe LLC · Merrill, ORN93020Red Leasing LLC · Juneau, AKN93022Red Leasing LLC · Juneau, AKN93023Ward Air Inc · Juneau, AK
Back to AD 87-20-03 R2