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.
N1474BSanderson David K · Scotts Valley, CAN1475ELittle Jack E · Granbury, TXN1475HHebbard Gary D · Bethel, OHN1475YAbe Lincoln Flyers Inc · Lincoln, ILN1476QHarley Dennis E Sr · Cole Camp, MON1476YHamilton Gene A · Saegertown, PAN1477FMavity Reagan Chase · Clayton, GAN1478DBailey James W Jr · Burleson, TXN1478FElliott Gabrial Adam · Hollywood, ALN1478YCunningham Richard E · Lafayette, CAN147HLeroy Philippe G · Willcox, AZN147PZZattoni Peter D · Mountain Iron, MNN1480BN1480b LLC · Wentzville, MON1481YPoole Timothy W · Lyons, GAN1482DSiebe Carl F · Anchorage, AKN1482YSamuelian Jenna A · Tehachapi, CAN1483DFlying Plane LLC · Bartow, FLN1483QAttax LLC · Missoula, MTN1483VRankin Kevin · Maryville, MON1484QIntegrated Structural Services Inc · Ringgold, GAN1484YHarrison Dennis N · New London, MON1485QMartin Aviation LLC · Bargersville, INN1486YPost Greg · Fort Scott, KSN14881Rhinehart Daniel · Placentia, CAN14882Registration Pending · Oklahoma City, OKRegistration pendingN14883Walker Bobbie R · Denver, CON14884Buck Carl W · Longmont, CON1488QTorney Sean M · Angier, NCN1489DAce Hole Flying Club LLC · Spokane, WAN1489FHoover Andrew V · Jenison, MIN148CKOtto David · Saint Thomas, MON148ELFrazier James M III · Saint Marys, KSN1490BEspinoza Cheryl · Littleton, CON1490DCole Daniel G · Pittsburgh, PAN1491HMacveigh Craig A · New Carlisle, OHN1491YBullard Thomas Eugene Trustee · Midlothian, TXN1492BSwift Johathan T · Castle Pines, CON1492DLevin Amanda L Trustee · Prairie Du Sac, WIN1492QDavison James D · Richmond, MAN1493DJobe Waylen Mark · Eugene, MON1493FAdventist World · Wilson, NCN1494DFuller Scott M · Edinburg, TXN1494FThompson Kevin L · Jefferson, TXN1494QSauter Allen · Bismarck, NDN1496FSmith James F · Red Springs, NCN1496QDonat Brandon L · Glendale, AZN1496YHoward Paul D · Gordon, TXN1497FBlunk Rodney · Bettendorf, IAN1497YHall Robert D · Prince-Frederick, MDN1499BWeaver Jack · Salt Lake City, UT
Back to AD 94-05-05 R1