AD 95-22-01
Registered aircraft · 5,258
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:95-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-22-01')
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:95-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-22-01') 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.
N123RCBwa Westwind 2 LLC · Orlando, FLN123TBTango Bravo LLC · Wilmington, DEN123TDVinanam Aviation LLC · Cupertino, CAN1249PTrns Solutions LLC · Lewes, DEN124HL4e Holdings LLC · Milwaukee, WIN124PMMc Air LLC · Mobile, ALN124RSHenley Charles D · New London, NCN1250VAquila Air LLC · Cincinnati, OHN12549Surdex Corp · Chesterfield, MON1255KCypress Aircraft Sales LLC · Clermont, FLN125CZN125cz LLC · Milwaukee, WIN125JJNeves LLC · Elizabethtown, KYN125RGAero South Florida Corp · West Palm Beach, FLN126CZN126cz LLC · Milwaukee, WIN126TFFox Lumber Sales Inc · Hamilton, MTN127CLWyoming Aviation LLC · Sheridan, WYN127CZN127cz LLC · Milwaukee, WIN127GKAlliance Aviation Group LLC · Wilmington, DEN127JMN127jm LLC · Clovis, NMN127PTN325nw LLC · Lodi, OHN127RGKlsit US Holdings LLC · Williams Bay, WIN127SRP Dussmann Inc · Beverly Hills, CAN127ZAMagic Carpet LLC · Wilmington, DEN128HL4e Holdings LLC · Milwaukee, WIN128MCDawson Aircraft Inc · Clinton, ARN129CZN129cz LLC · Milwaukee, WIN129LTTnl Management LLC · Cullman, ALN129NSHarvey Horses LLC · Wilmington, DEN129PBSmaf Environmental LLC · Prineville, ORN129RPN129rp LLC · Tulsa, OKN129TKBankair Inc · West Columbia, SCN129TWLogistic Air Inc · Reno, NVN12FDN12fd LLC · Memphis, TNN12FNGh Equipment LLC · Dover, DEN12JEProfessional Pilot Training Inc · Eagle Lake, TXN12LDSouth Georgia Motor Sports LLC · Wilmington, DEFirst renewal noticeN12RPRoyal Air Freight Inc · Waterford, MIN12SBSilvano Sal · La Grange, KYN1303BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN13092Nxt LLC · Oklahoma City, OKN130JEReserve Jets Acquisitions LLC · New York, NYN130RACarter Distribution Lc · Salt Lake City, UTN13110United Airlines Inc · Chicago, ILN13113United Airlines Inc · Chicago, ILN13138United Airlines Inc · Chicago, ILN1316RAirgo Partners LLC · Lititz, PAN131JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN131RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN13227United Airlines Inc · Chicago, ILN13248Umb Bank Na Trustee · Salt Lake City, UT
Back to AD 95-22-01