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.
N9723HFlying Tigers Flight School LLC · Houston, TXN9723TLuinstra Lee Vernon · Benton, KSN9723XThornton James P · Amesbury, MAN97240N97240 LLC · Amherst, MAN97246Duggins Robert W · Van Nuys, CAN97257Moser Keith W · Huntington, INN9725GMathis Isaac Thomas · Fletcher, NCN9725QWings Over Texas Holdings LLC · Denton, TXN9725RLongitude 150 LLC · Anchorage, AKN9725TAnderas Per R · Green Bay, WIN9725VAnderson Aerial Spraying Service Inc · Canby, MNN9725XNewling Galen J · Bremerton, WAN97266East Hill Flying Club · Ithaca, NYN97269J&L Aviation LLC · Malta, NYN9726GIrc Holdings Ltd · Allentown, PAN9726TBuettner Casey R · Kearney, NEN9727ACaughlin David Drew · Boise, IDN9727GInternational Air Services Inc Trustee · Carson City, NVN9727TRogers Bob · Mountain Green, UTN9727VDills John H · Ione, WAN97281Wackerli Steve B · Idaho Falls, IDFirst renewal noticeN97282Jav Air Services LLC · Anchorage, AKN97288Bolle Aviation LLC · Clare, MIN9728ADailey Brian A · Strongsville, OHN9728BLowery Janell D · Anchorage, AKN9728MGrant Aviation Inc · Anchorage, AKN9728TBanks Trevor A · Thomaston, GAN97295J-Air LLC · Guthrie, OKN97298Roberts And Connell Llp · San Luis Obispo, CAN9729ABaker Benjamin D · Catasauqua, PAN9729BAnderson Benjamin T · Havre De Grace, MDN9729GBurch Gerald T · Lake Charles, LAN9729TGibbs David F · Greenville, NCN972DPCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN972FCBlackhawk Holding Corp · Wilmington, DEN972LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN972MAAir Repair Inc · Easton, MDN972NCIal Corp · Lewes, DEN972PMNp Aviation Inc · Naguabo, PRN97300Jaeger Kurt · Bermuda Dunes, CAN97309Afana Lawrence L Jr · Phoenix, AZN9730GMcginty Flying Service LLC · Jones, LAN9730VWings Over Texas Holdings LLC · Denton, TXN9730XHaase Herman · Stockton, CAN97311Christiansen Aviation LLC · Wilmington, DEN97313Civil Air Patrol Inc · Maxwell Afb, ALN9731ANorbury Frank R · Scottsdale, AZN9731HCreative Strategies Inc · Proctorville, OHN9731TKarren Robert E · Mountain Home, IDN9731XPoe David A · Big Sandy, TX
Back to AD 87-20-03 R2