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.
N55144Bell Air LLC · Las Cruces, NMN55146Sky High Aviation LLC · Gonzales, LAN55148Lierle Sidney D · Clearlake, CAN55149County 17 Aviators LLC · Gillette, WYN5514FWingrove Rodney W · Vincent, OHN5514LFlight School Of Gwinnett Inc · Lawrenceville, GAN5514MPruitt Buster Jr · Shelbyville, TNN5514PCohran Enterprise LLC · Pineville, LAN5514QKurtz Hans E · Clewiston, FLN5514UCheckers Investments Inc · Edmond, OKN5514ZWilkinson Bruce O · Williamsburg, VAN55150Alexander Dennis K · Gallatin, TNN55151Learn 2 Fly LLC · Cantonment, FLN55154Kanpahem Aviation LLC · Hawkins, TXN5515LDoody Michael C · Knoxville, TNN5515MBarringer William R · Benbrook, TXN5515QLassiter Bobby L · Newport, ARN5515SGotay Ricardo M · Watertown, CTN5515VMt Aircraft LLC · Port Orange, FLN5515ZLandrum Kelly T · Halifax, VAN55160Davis Joseph S · Andalusia, ALN55163Jackson Donald W · Carthage, MSN55166Volando LLC · Columbia, MON55167Flyboys Nevada LLC · Henderson, NVN55169Jin Jin Aviation LLC · Anchorage, AKN5516FMoore Marcus · Auburn, ALN5516JRobarge Andrew Michael · Crown Point, INN5516LBarnes Richard A · Federal Way, WAN5516SAtc Trucking Inc · Miami, FLN5516UHicks David A · Beaver Dam, WIN55173Dareing Chon · San Antonio, TXN55176Hall Davis · Mobile, ALN55177Saunders Ivan J · Margate, FLN55179Rick Aviation Inc · Newport News, VAN5517FMccarthy Mark C · Russellville, ARN5517JGiblin Daniel P · Loveland, OHN5517KCarter Brantley F · Timmonsville, SCN5517MBas Part Sales LLC · Greeley, CON5517PVoorhees Kenneth J · Aiea, HIN5517QTrayhan Edward J · Schertz, TXN5517VWest Bryan M · Heath, TXN5517ZTravnicek Sandy R · Bowie, TXN5518Campbell Larry L · Fort Mill, SCN55181Bluewater Airmotive Corp · Wilmington, DEN55182Sofla Sky Solutions LLC · Deerfield Beach, FLN55185Bailey Richard W · Auburn, ALN55187Aerospace Trust Management LLC Trustee · Wilmington, DEN5518GChristiansen Aviation LLC · Wilmington, DEN5518JEbaugh Michael D · Port Saint Lucie, FLN5518KDiaz James F · Campbell, CA
Back to AD 81-18-04 R2