AD 2001-12-01
Registered aircraft · 1,309
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:2001-12-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-12-01')
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:2001-12-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-12-01') 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.
N2316XJnj Aviation Inc · Wilmington, DEN231CMQet Aircraft Services LLC · Rancho Viejo, TXN2325DBeck Sod Farm Inc · Palms, MIN2325JLesterville Land Holdings LLC · Ellington, MON234AGLop LLC · Orangeburg, SCN234PMDiamond Enterprises LLC · Lincoln, NEN235TWSalcedo Enrique · San Diego, CAN2365SIe3 Enterprise LLC · Elk Grove, CAN2369AValiair Lc Trustee · Casper, WYN237CLnh Holdings LLC · Richardson, TXN237JMBrekke Aviation Inc · Edmore, NDN237MAR E Dimond And Associates Inc · Indianapolis, INN237STIlluminus Aviation LLC · Chicago, ILN23DKStockwell Aviation LLC · Clarence Center, NYN2406PAam Aeromed LLC · Wilmington, DEN240ERAlexander Aviation LLC · Scottsdale, AZN2413ACotner Jeffry J · Houston, TXN2418WSierra Tango Air LLC · Sycamore, ILN241DGJust Plane Fun · Santa Barbara, CAN241PMBryants Aviation Inc · Batesville, ARN2424UOregon Air Classics LLC · Fife, WAN242MJWch/Lgs Sky Ventures LLC · Littleton, NCN242WFN242wf LLC · Wilmington, DEN244DFPapa 46 Ventures LLC · Ellenton, FLN244LMSunset Horizons LLC · Clovis, CAN245EABlue Heron Aviation LLC · Port Orange, FLN245SSharpaire LLC · Wilmington, DEN246LRegistered aircraftN247TJNicholas Sol · Colorado Springs, CON248DAJb Air Services LLC · Brighton, CON249FBK4m Aviation LLC · Marksville, LAN250BTHeart Gate Enterprises LLC · Pittsburgh, PAN250DFDmfs Leasing LLC · Des Moines, IAN250SAAircraft Partner Holdings Inc Trustee · BerlinN25120Waconda Concepts LLC · Sturgis, SDN2519FAmerican Aviation Inc · Brooksville, FLN2529XCpdl Pm LLC · Dallas, TXN252CValiair Lc Trustee · Casper, WYN252MJThorpe Curtis D · Fredericksburg, TXN25324Central Valley Air LLC · Logan, UTN253HLIscil Kaan · Miami, FLN253MAHoosier Doc LLC · South Bend, INFirst renewal noticeN2545HNoble Aviation Enterprises LLC · Phoenix, AZN254HTFly254 LLC · Waco, TXN255DWHales Gutter Guys LLC · Sedona, AZN255RZIsr Aviation LLC · Wilmington, DEN2569YDavidson James E · Bothell, WAN257LGClear Sky Aviation LLC · Coral Springs, FLN25906Valiair Limited Co Trustee · Casper, WYN2590UBlue & Gold LLC · South Boston, VA
Back to AD 2001-12-01