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.
N2665LKay Bennie L · Brigham City, UTN2666URegistration Pending · Decatur, TXRegistration pendingN2666VWalden James F · Willcox, AZN2667VPfunke Mark E · Chester, NJN2668LEnnis Shannon E · Chesapeake, VAN2668UMid South Aircraft Inc · Gadsden, ALN2668VPlane Fun Inc Tr Trustee · Snellville, GAN2669EScrews Harlan D · Vernon, TXN2669KSherman Joseph R · Rio Rancho, NMN2669LRotormate LLC · Royse City, TXN2669VMartin Brian J · Grayslake, ILN266AEnterra LLC · Aroda, VAN2670DBoggess William C · Placerville, CAN2670JMiw Airmen Inc · Marshalltown, IAN2670LOns Bart · Kirkland, WAN2670VRetro Air LLC · Seattle, WAN2671JSherman Phillip A · Mansfield, OHN2671LNbl Aviation LLC · Woodway, TXN2671NKrajci Michael T · Yardley, PAN2671UMetz Thomas H · Mifflintown, PAN2672FWright James F · Glenford, OHN2672KHoward David D · Winner, SDN2672NBartholomew Jim F · Storm Lake, IAN2672UBender John Lowell Trustee · N Richland Hills, TXN2673JWest David V · Sandusky, OHN2673LBalcom Terry J · Shepherd, MIN2673UBonin Patrick G · Blossvale, NYN2674DKnefley Michael · Ulysses, PAN2674LValley Excavation And Grading Inc · Chatsworth, CAN2674NHillmer Daniel M · Manitowoc, WIN26753Steube George · Jackson, MSN26754Esterly Bryan L · Hope Mills, NCN2675LFoster Jeffrey W · Lexington, NCN2675NMurrell James F Sr · Douglas, AZN2675UAv Hawk Aviation LLC · Montclair, NJN2675VHartis Christopher · Newman Lake, WAN26762Barlow James D · Mohave Valley, AZN2676DLamott Brenda I · Boise, IDN2676LCupp Stanley J · Quilcene, WAN2676URobinson Dalton M · Londonberry, OHN2677ETodd Michael E · Yelm, WAN2679DHoppe Air LLC · Beaman, IAN2679JJupiter Flight Service And Investing LLC · Lithonia, GAN2679LBartley James K · Kent, WAN267EEvenson Charles R · Saint Charles, MON267NMNygaard Michael A · Black Hawk, SDN267RJRc Aero LLC · Richmond, INN267SASmith Fred · Houlka, MSN26809Johnson Joyce C · Cumberland, MDN2680KLill Stephen P · Lafayette, LA
Back to AD 94-05-05 R1