AD 2001-03-06
Registered aircraft · 328
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:2001-03-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-03-06')
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:2001-03-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-03-06') 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.
N505XPMrbeastyoutube 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, DEN675UPWheels Up Partners LLC · New York, NY
Back to AD 2001-03-06