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.
N991ACXin Han Aviation LLC · Randolph, MAN991BCHusby Jeffrey L · Eau Claire, WIN991BJSilver Express Co · Miami, FLN991CBBorg Derek F · Dallas, TXN991DCFigueroa Lionel Xavier · Sacramento, CAFirst renewal noticeN991FGFlightgest Academy LLC · Morrisville, NCN991GBTempleton Robert P · La Jolla, CAN991JAEuroaviation Inc · KematenN991KCSalt Lake Community College · Salt Lake City, UTN991KERaper Sandra K · Mesa, AZN991RBSchuerman Rodney L · Anchorage, AKN991RRSale Reported · Inman, SCSale reported, canceledN991SESoutheastern Oklahoma State University · Durant, OKN991SWLeston Peter M · Mansfield, MAN991TALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYN991VTCrosswinds Flying Club Inc · Bloomington, ILN992Baker Duke I · Jackson, MSN9920BSchultz Robert G · Baker, FLN9920LLarson Kris Kendrick · Fullerton, CAN9920UQualitair LLC Trustee · MichelstadtN9920VSkywarrior Flight Training Inc · Pensacola, FLN9921UKing Dennis D · Venice, FLN9921WPhoenix Composite Solutions LLC · Oscoda, MIN9922UOwen Christian B · Ontario, CAN99243Wings Over Texas Holdings LLC · Denton, TXN9924BNatre Air II LLC · Tipton, INN9924DFoshee Todd · Brownfield, TXN9924QMy Way Aviation LLC · Weston, FLN9924VEdwards Kevin M · Grass Valley, CAN9924WFlydunn.Com Inc · Jacksonville, FLN99253Mitiguy Aviation LLC · Stow, MAN9925DZaczkowski Paul S · Tok, AKN9925HScientific Aerial Imaging Inc · Saint Helena, CAN9925LNeuroth Kurt V · Saint Charles, MON9925QRoeder Cara R · Lake Charles, LAN9925UNguyen Vincent Lam-Son · Fountain Valley, CAN9925VGoodin Joshua W · Jacksonville, FLN9925WBigler Danny L · Owasso, OKN9925YDaniel Hull R · Wasilla, AKN99263Wings Over Texas Holdings LLC · Denton, TXN99265St Pete Aviation Services LLC · Saint Petersburg, FLN9926YMorgan Kenneth K · Norridgewock, MEN99273United States Air Force · Dover Afb, DEN9927QAndrus Shane · Pullman, WAN9927USpotts James J · Henderson, NVN9928LCarpenter Kenneth D · Tempe, AZN9928QDavis John · Jackson, WYN9928RJablonski Kenneth · Ann Arbor, MIN9928ULarson John B · Bloomington, MNN99295Sky Warrior Flight Training Inc · Pensacola, FL
Back to AD 81-18-04 R2