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.
N35BZKapusniak Slawomir · Easton, PAN35CFGilbert David · Othello, WAN35CGComesa Service Group · Middletown, DEFirst renewal noticeN35CKColeman Tyler R · Sierra Vista, AZN35CLScherer Zebulon R · Anchorage, AKN35CPRayl Curtiss C · Pensacola, FLN35CWTimoney James M · Auburn, MEN35DQPalone Vincent E · Waynesburg, PAN35DTTeufel Armin U · Phelan, CAFirst renewal noticeN35ECKoda Bear Properties LLC · Wilmington, DEN35EKHaupt Erik · Great Barrington, MAN35ESMurphy Joel · Flowermound, TXN35FCook Stephen D · Osceola, INN35FASt Louis Soaring Association · Saint Louis, MON35FBEwins John H · Danville, CAN35FCTransonic Inc · Auburn, CAN35FLWhitcomb Keith · Villa Rica, GAN35GMSt Cloud Flying Club LLC · Saint Cloud, MNN35GPLimon Hector Jr · Lubbock, TXN35GVMartin Scott W · Bowie, MDN35HBDownes Greg · Iowa City, IAN35HPQualitair LLC Trustee · MichelstadtN35HRTrantina Robert J · Desert Aire, WAN35HUFilimoehala Nicholas C · Kaysville, UTN35HVProdigy Aviation LLC · Port Orange, FLN35JSkybound Shenanigans LLC · Dubuque, IAN35JCRogowski Paul · Dallas, GAN35JFBerry Damon R · Granbury, TXN35JGJalu Financial Corp · Gray, GAN35JTBeech 36 LLC · Siloam Springs, ARN35JWN35jw LLC · Enid, OKN35KKearns Jeff C · Carrier Mills, ILN35KAHacker Timothy J · Pangburn, ARN35KCBuchanan Tevah · St George, UTN35KJBunn John Timothy · Winter Garden, FLN35KWCoy Walter Thomas · Titusville, FLN35LABohachevsky John V · Bloomfield, KYN35LBWebb John M · Chugiak, AKN35LCClaussen Larry Scott · Independence, ORN35LFPlane Fun Inc Tr Trustee · Snellville, GAN35LGAnderson Charles · Bakersfield, CAN35LVDelta Fox Aviation LLC · Fort Worth, TXN35MSimmons Dennis L · Wichita, KSN35MASidetrack Investments LLC · Flower Mound, TXN35MBBarker Max · Caldwell, IDN35MDGarbalosa Ryan · Myrtle Beach, SCN35MLNelson Aircraft Sales Inc · Minot, NDN35MQFly Planet LLC · Kalispell, MTN35MTToft Michael O · Brock, TXN35MVWeaver Kibwe · Kalamazoo, MI
Back to AD 2007-04-19 R1