AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N51209Green Harvey D · Germantown, TNN5120ALane Christopher A · Lakeland, GAN5120FUnited States Air Force · Jacksonville, FLN51219Szostak Edward M · San Diego, CAN51223James Joseph E · Janesville, WIN51224Rettenmeyer Ryan J · Buford, GAN51225Riccelli Zack Louis · Portland, ORN5122FRay Richard H · Franklin, GAN51232Hawk Hangars Corporation LLC · Jenks, OKN5123AGrabenstein Walter L DBA · Bradenton, FLFirst renewal noticeN51251Technical Education Services Inc DBA · Virginia Beach, VAN51256Miller Andy · Marana, AZN51257Burnham Nathaniel · Eagle Mountain, UTN51258Nelson Otis · Portage, MEN5125FEckles Aircraft LLC · Holdenville, OKN51266Reiter Marc · Hooks, TXN5126FEkblad Carl A · New Port Richey, FLN51275Hollow David C · Knoxville, TNN5127FDolan Ross R · Portland, MEN51284Stallbaumer Roger P · Seneca, KSN51285Bk Aviation Inc · Grand Prairie, TXN51287Personal Air LLC · Wilmington, DEN51288Cantley Richard W · Bluff City, TNN51292Herbert William N · Anchorage, AKN512ADDiffenderfer Andy C · Horseheads, NYN512PGGrassroots Flying LLC · Bellevue, NEN512RSchappert Jason M · Naples, FLN51304Stewart Roy L · Roy, UTN51306Durand Gregory M · Marquette, MIN51314Scott John J · Arcadia, FLN51317Spitzer Terry E · Kalona, IAN5131AJohnson Basil · Tucson, AZN5131FWoerle Edward R · Rossville, TNN51323Rathnayake Eric · Collegeville, PAN51326Lapoint Paul E · Drummond Island, MIN51327Bowles Alan B · Georgetown, TXN51328Butterfield Charles D · Eskridge, KSN51333Blazey John Stanley · Palmyra, NYN51334Cragg Noel J · Millbrae, CAN51337Garner Charlotte Trustee · Sun Lakes, AZN5133ALake Area Technical Institute · Watertown, SDN51343Tucker John D II · Fayetteville, GAN51345Arizona Aircraft Leasing LLC · Mesa, AZN51347Bernhardt Michael J · North Branch, MNN5134MAnderson David M · Browns Valley, CAN51355Miller Judith A · Homer, AKN5135BMekkes Gregory L · Norfolk, VAN5135QOlivas Frank · Fabens, TXN51365Cavu Pilot LLC · Powell, TNN51367Wings Over Texas Holdings LLC · Denton, TX
Back to AD 94-05-05 R1