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.
N586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN586RHLugar Daniel A · St Helena Is, SCN586SRice James L · Mckinney, TXN586SBKareon Consulting LLC · Wilmington, DEN586TSUniversity Of North Dakota · Grand Forks, NDN587Plane Management LLC · Conroe, TXN5870PPaul Eric C · Grapevine, TXN5870QScott Stewart · Columbia, MON5870UWhite Thomas A · Roanoke, TXN5871LSleeper James A · Middleburg, FLN5871NBraun Janet M · Pocono Pines, PAN5871PHammons John A · Maurice, LAN5871QNeosho Investments LLC · Neosho, MON5871ZJohnson Nathan P · Rapid City, SDN5872LMai David A · Chattanooga, TNN5872NMeans Loren Alonzo III · Wasilla, AKN5872QAir Mods And Repair Inc · Robbinsville, NJN5872ZCollins James T · Blossvale, NYN5873QSternhagen Richard A · Friendship, WIN5873WPropst David A · Exchange, WVN5873ZSchramm Thomas L · South Rockwood, MIN5874DFeuerborn Ethan T · Boise, IDN5874UFlying Wright Aviation LLC · Henderson, NVN5874ZGodbey Patrick · St Simons Island, GAN5875HPresten Eric A · Vineburg, CAN5875UTews Jamie S · Greenville, WIN5875VCrew Michael A · Phoenix, AZN5875ZReed John F · Bemus Point, NYN5876DKirkendall James · N Richlnd Hls, TXN5876LWilson James · Bagwell, TXN5876U3shahs Aviation LLC · Temecula, CAN5876WKiss George C · Bangor, PAN5876ZDraper Scott · Rutland, VTN5877FFeldvary John · Jackson, MIN5877LFlyboys Aviation LLC · Sioux City, IAN5877NMeisner Shane · Fredericksburg, VAN5877QKenyon Alexandrea A · Costa Mesa, CAN5877VWest Keith W · Slatington, PAN5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYN5878GConner Norman V · Lakewood, WAN5878HDelaware Taildraggers LLC · Hancock, NYN5878LGomez Blanco Rafael · Lakewood, CAN5878UAlbright Jasper N · Raleigh, NCN5878WWorrell Wayne · Campbellsville, KYN5878ZSallmon James H · Saratoga Springs, UTN5879HParlin Larrol L · Friday Harbor, WAN5879LN5879l LLC · Lewes, DEN5879NBas Part Sales LLC · Greeley, CON5879UJacobs Levon Jr · Oak Hill, FLN587AMPerry Monty R · Simi Valley, CA
Back to AD 81-18-04 R2