AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N5588UMontgomery Richard E · Omaha, NEN5588WBartz Nicole · Cleveland, MON5588ZSpooner John A · Hickory, NCN55890S & L Sports LLC · New Hampton, IAN55899Aerospace Trust Management LLC Trustee · Wilmington, DEN5589FTjl Aviation LLC · Atlanta, GAN5589HAdams Trevor J · Burlington, WAN5589JFrank Investments Inc · Austin, TXN5589PEggers Cindy S · Winnemucca, NVN5589UGq Aviation LLC · Cherry Hill, NJN5589ZDayton Stephen G · Littleton, NHN558AGalindo Don R Jr · Walnut Grove, CAN558AZHess Michael R · Alexandria, VAFirst renewal noticeN558CPCivil Air Patrol · Maxwell Afb, ALN558EAerodyme Corp · South Burlington, VTN558FLRoyal Greene Holdings LLC · Spout Spring, VAN558JRichley Robert C · Lees Summit, MON558KAtp Aircraft 3 LLC · Wilmington, DEN558MASanders Flight Training Center Inc · Jasper, ALN558MBBarrow Michael B · Reno, NVN558NDPhoenix East Aviation LLC · Daytona Beach, FLN558PCSammons Aero Services LLC · Edgewood, TXN558PPTaylor Thomas J · Sharpsburg, GAN558RBNash Garrett J · Bliss, IDN558SHAarow Aircraft Leasing LLC · Mcminnville, ORN558SMTsvang Volodymyr · Redondo Beach, CAN558TLLally Timothy A · Bell Gardens, CAN55905Top Coat Takeoff LLC · Cincinnati, OHN55907Gregg Jeffrey B · Sun Valley, CAN5590FLee A Archer Jr Red Tail Youth Flying Progrom Inc · New Windsor, NYN5590HZonnefeld Mark J · Olathe, KSN5590JWilliams John S · Cleveland, TXN5590PUdall Thomas H · Mckinney, TXN5590ZWhitaker Shawn P · Mount Pleasant, SCN55913Buckner Business Services Inc · Trenton, MON55915Loncella James G · Johnstown, PAN55919Northstar Group LLC · Dothan, ALN5591WMontag Mark W · Pine River, WIN55920Gillbreath Monty Everett · Livingston, TXN55925Goodwin Collin H · Hobbs, NMN55928Tao Aviation LLC · Las Vegas, NVN5592FEagle Air Flying Club Inc · Bowling Green, OHN5592JHyden Josh Vander · Beulah, MIN5592PWelch Roy T · Garfield, WAN5592QGrant Charles A Jr · Denton, TXN5592VBlack Dog Air LLC · Satellite Beach, FLN55930Lafrance Troy R · Paola, KSN55932Red Eagle Aviation LLC · Deridder, LAN55933Knoxville Aviation · Knoxville, IAN55934Roloff Paul E Trustee · Waupaca, WI
Back to AD 81-18-04 R2