AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1277WRush Aviation Rentals Inc · Meridian, IDN1277XDuke City Mooney LLC · Lakewood, CON127826350 LLC · Yorklyn, DEN1278JBallester Alexis R · Mayaguez, PRN1279XRegistered aircraftN127AKSwan Logistics LLC · Toledo, OHN127ATAirline Transport Professionals Corp Of USA · Wilmington, DEN127AVPlane Fun Inc Tr Trustee · Snellville, GAN127BDRegistered aircraftN127CGRegistered aircraftN127DMAircraft Leasing LLC · Peoria, ILN127EYoung John C · Olathe, KSN127EMKrein Chris · Bismarck, NDN127GT7 Golf Tango LLC · Saint Petersburg, FLN127HFHeritage Asset Leasing LLC · Ronkonkoma, NYN127JNNewman Jimmie L · Davenport, FLN127KHCentral Airlines Inc · Overland Park, KSN127KJSky Flowers Holding Group LLC · Sunrise, FLN127KWElizabeth City State University · Elizabeth City, NCN127LFFisher Nicholis W · Springfield, LAN127MDCosbie Lee R · Tuscumbia, ALN127PMinard Robert Myron Jr Trustee · Laveen, AZN127PSParsa Aviation LLC · Boca Raton, FLN127SAVintage Tailwheel LLC · Wilmington, DEN127SHWaverly R22 LLC · Oklahoma City, OKN127SLGulf Coast Helicopters Inc · Pearland, TXN127TGEberle Brian J · Newnan, GAN127TZMeng-Hannan Construction Inc · Portland, ORN127VGEvans James F · Columbus, GAN127WMMagnum Consulting Group Inc · Scottsdale, AZN127XKilgore Sky LLC · Parker, AZN1280KChristiansen Aviation LLC · Wilmington, DEN1280TCertified Equipment Inspections LLC · Washington, PAN1280XErlandson Michael D · Salt Lake City, UTN1281KKirkwood Billie R · El Paso, TXN1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CAN12828Fulwiler Air LLC · Green Bay, WIN1283HMurphy George W · Willow, AKN1284NAbnc Air LLC · Wellington, FLN1284WBethel Don G · Bossier City, LAN1284ZDubose Alexander R · Durham, CAN1285ROrbit Aviation LLC · Lakewood, CAN12868Gregg William V · Greensburg, PAN1286JDillman Neal A · Davis, CAN1286THeffelfinger Paul D · Seven Valleys, PAN1287ECrown Coast LLC · Costa Mesa, CAN1287TBelle Casa Aero LLC · Tarpon Springs, FLN1289XConner James B · Mishawaka, INN1289YBravo Leasing LLC · Daytona Beach, FLN128AGarza Family LLC · Helena, MT
Back to AD 2006-10-21