AD 2002-01-23
Registered aircraft · 329
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-01-23')
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-01-23')
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-01-23') 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-01-23') 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.
N5031TSky West Aviation Inc Trustee · Albuquerque, NMN505XPMrbeastyoutube LLC · Greenville, NCN507WMDjkk LLC · Moon Twp, PAN512FBeechjet LLC · Mankato, MNN515RYAviation Trust Company LLC Trustee · Oklahoma City, OKN515TJBlackburn International Inc · Lewes, DEN51BBank Of Utah Trustee · Salt Lake City, UTN520TMN720cj LLC · Williamsburg, VAN520WSMmu Aviation LLC · West Orange, NJN523AJAj Dwoskin & Associates Inc · Fairfax, VAN527PMPmsr LLC · Davenport, IAN530TMBravo Mike Sierra LLC · Dallas, TXN541HC541hc LLC · Salem, ORN547MTMtj Aviation LLC · Mooresville, NCN548KKBlue Hawk Co LLC · Cottonwood, CAN54FBFbl Leasing Services Inc · West Des Moines, IAN54HPIal Corp · Lewes, DEN552CCAvex Xiv LLC · Fort Lauderdale, FLN55YSSuperior Aviation Inc · Orlando, FLN560MTMtj Aviation LLC · Mooresville, NCN562MTMtj Aviation LLC · Mooresville, NCN563RJTop Gun Air LLC · Pompano Beach, FLN567XPSociety Skies LLC · Charlotte, NCN575RBAircraft Holding Solutions LLC Trustee · Newark, DEN578BBAircraft Trustee Services Inc Trustee · Dover, DEN57MQTranscredit Services LLC · Centreville, ALN580RKHincojet LLC · Portage, MIN582JMInbound LLC · Overland Park, KSN598DRDrct II LLC · Maple Grove, MNN599TMAdams Aviation Services Inc Trustee · Wilmington, DEN600GWG3x Aerospace Inc · Dover, DEN602JCFirst Frontier Bc LLC · Duncansville, PAN605NTNorjet LLC · Cape Coral, FLN60EFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN615HPHighwoods Properties Inc · Raleigh, NCN615KZAlliance Aviation Group LLC · Wilmington, DEN615SFTsan Leasing LLC · Nashville, TNN619GPatriot Flight LLC · Jacksonville, FLN61GBKilo Papa LLC · Grand Island, NEN61VCPeaceable Partners LLC · Ridgefield, CTN625WSundance Aviation LLC · Lincoln, NEN652KBAvex Xii LLC · Fort Lauderdale, FLN655CMWoodland Ranch LLC · Odessa, MON65RASky Cloud Ventures LLC · Seagrove Beach, FLN65SQMtj Aviation LLC · Mooresville, NCN660CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN661WDEncore Jet Management LLC · San Antonio, TXN671UPJersey Aviation LLC · Stamford, CTN673UPWheels Up Partners LLC · New York, NYN674DJFalcon 7 LLC · Wilmington, DE
Back to AD 2002-01-23