AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N39AHCapital Aircraft LLC · Juneau, AKN39AKRenfro Michael W · Bethel, AKN39ALMcentire David J · Bainbridge, INN39BCRoberts David C · Cedar Falls, IAN39BPEmerald City Aircraft Leasing Inc · Port Orchard, WAN39BSTravark LLC · Gainesville, GAN39BTMidwest Aerial Photography · Galloway, OHN39CCWard Bobby J · Dalhart, TXN39CMZarum Robert S · Mashpee, MAN39CPWhirl'D Helicopters Inc · Sevierville, TNN39CSRegistration Pending · Pinckney, MIRegistration pendingN39CTRotramel Paul D · Hardinsburg, KYN39CWWindham Charles R · Rogersville, TNN39DBKwasinski Mark W · Kalamazoo, MIN39DCCruson Dale E · Ontario, ORN39DDLarson Danny O · Palmer, AKN39DRLehigh Valley Flying Club Inc · Lehigh Valley, PAN39DUYokoo Kureha · Petaluma, CAN39ECSmith Adria A · Kingwood, TXN39EJAndersen John · Kenosha, WIN39FCStout Keith · Salmon, IDN39FZLongley Charles A · Nome, AKN39GMonteleone Gene R · Mount Vernon, TXN39GCWilliams Jeffrey D · Florence, ALN39GDNovember Sierra Romeo LLC · Byron Center, MIN39GHApaka Lee K · Fairfield, CAN39GMBacon Gregory A · Prairie Home, MON39GPExtra 2 Inc · Newark, DEN39GSAir Flight Enterprises Inc · South Daytona, FLN39GTAshwill Gregory L Trustee · Overgaard, AZN39GWKotalite Consultant LLC · West Palm Beach, FLN39HBBartle Henson P · Independence, ORN39HCTherapy Air LLC · Midland, TXN39HWApple & Vine Aviation Services LLC · Reidsville, GAN39HYReed Hollow Aviation LLC · Franktown, CON39JApex 1996 LLC · Kilgore, TXN39JBHarvey Hath R · Lubbock, TXN39JLLundberg Jonathan S · Fayetteville, TNN39JMJads Aviation LLC · Rowlett, TXN39KWFier William J · Austin, TXN39LDMau Thomas E · Kenmare, NDN39LTGeorgia Forestry Commission · Macon, GAN39MPMission Aviation Training Academy · Arlington, WAN39MRGraupman Gerald · Chicago, ILN39MVMedical Transport Inc · Dover, DEN39NDTerwillegar Charles E · Renton, WAN39NSMacair Inc · Corvallis, ORN39PCN39pc LLC · Portsmouth, NHN39PRAeroplanes LLC · Cary, NCN39PSSmith Justin Dean · Dayton, TN
Back to AD 2007-04-19 R1