AD 2002-23-19
Registered aircraft · 486
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:2002-23-19')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-19')
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:2002-23-19') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-19') 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.
N541FBank Of Utah Trustee · Salt Lake City, UTN541ZBank Of Utah Trustee · Salt Lake City, UTN542TPLakeridge Holdings LLC · Portland, ORN54MHTvpx Msn 390 Business Trust · North Salt Lake, UTN54YRPhifer Inc · Tuscaloosa, ALN552GRGrp Aviation LLC · Van Nuys, CAN553GRRivers Edge Equipment Leasing LLC · Springfield, ILN555GSInvestjet LLC · Miami, FLN555HGShort Hills Aviators LLC · Morristown, NJN555MKNgl Aviation Tul LLC · Tulsa, OKN5567AAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN556KMFifty-One Air LLC · Lampasas, TXN558RCovenanter Investments II LLC · Nashville, TNN560USTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN570DWarbler I LLC · Freeland, MIN575TCTroy Equipment Holdings LLC · Houston, TXN584VWilmington Trust Co Trustee · Wilmington, DEN58MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLN595PDirect Ventures Management LLC · Knoxville, TNN599GJLham3 LLC · Plainfield, INN599PCBank Of Utah Trustee · Salt Lake City, UTN600CNChickasaw Nation · Ada, OKN603CNChickasaw Nation · Ada, OKN603GJRegistered aircraftN609GJBank Of Utah Trustee · Salt Lake City, UTN610GJDirect Ventures Management LLC · Knoxville, TNN611EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN613BDLynx Medical Transport LLC · Cincinnati, OHN613CSAvlease Company LLC · Ann Arbor, MIN61JEJce Leasing LLC · Little Rock, ARN621HDXls Aviation LLC · Effingham, ILN623HDK & M Aviation Holdings I LLC · Hartville, OHN623RMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN627LGLive Mas Enterprises LLC · Greenwood Village, CON62LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN630BANix Patterson Llp · Austin, TXN630VCAnanim LLC · Lincolnwood, ILN632PBModern Transportation Company Inc · Owensboro, KYN639MWilmington Trust Co Trustee · Wilmington, DEN63FSIron Senergy Legacy LLC · Louisville, KYN640MSArtis 1 LLC · Miami, FLN644RVFrankcrum Corporate Inc · Clearwater, FLN659FMThayer Acquisitions LLC · Mclean, VAN666TRDrt Falcon LLC · New York, NYN66MDWorthida Co LLC · Palm Beach, FLN671HSEvans Aviation Holdings LLC · College Grove, TNN672WBRegistered aircraftN-number assigned (import), not yet registeredN67AFAir4 Aviation LLC · Houston, TXN67RTRegistered aircraftN680SFEh Air LLC · Canton, OH
Back to AD 2002-23-19