AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N401TJHyannis Air Service Inc · Hyannis, MAN401TMBlue Skies Over The Creek LLC · Port Orange, FLN401TTSolomon Colors Inc · Springfield, ILN401WMMrd Aero LLC · Manheim, PAN401ZPSchrader Adam · Spicer, MNN402AJ2lyons Enterprises LLC · Wellington, FLN402BCDssr22 LLC · Troy, MTN402BFSnell Marion Lea · Ackerly, TXN402BKN402bk LLC · Nantucket, MAN402CENorth American Aerial Surveys LLC · Tucson, AZN402CKEpok LLC · Wrightsville Beach, NCN402CZEmission-Air Inc · Welcome, NCN402DZSamadi Jamshid · Leesburg, VAN402EASneed Leasing LLC · Nashville, TNN402HEHendrickson Logan · Omaha, NEN402HGHyannis Air Service Inc DBA · Hyannis, MAN402JHAir Flight Inc · Fort Lauderdale, FLN402NKKhan Pervez · Miami Springs, FLN402PAAir Flight Inc · Fort Lauderdale, FLN402RSTropical Transport Services Ltd · San Jaun, PRN402SAAlly Mohamed Yacoob · Fort Lauderdale, FLN402SBGlemone Airways Inc · Wilmington, DEN402SSKellair Ltd Inc · Sunrise, FLNon-citizen corporation, flight hours not reportedN402VNHyannis Air Service Inc · Hyannis, MAN402WFJpm Management Group LLC · Ashland, NEN402WWPark Avenue Group Inc · Stuart, FLN402ZKAirplane One LLC · Miami Springs, FLN4031Panda Bear Aviation LLC · Dripping Springs, TXN4032CKrs Aerial Inc · Galloway, OHN403AJAero Jet Aviation I Inc · Fort Lauderdale, FLN403CDSma Air LLC · Lindstrom, MNN403CTCat Aviation LLC · Big Sky, MTN403KGN403kg LLC · Muskegon, MIN403LDUngerecht Lyle · Independence, ORN403PLAircraft Partners LLC · Tampa, FLN403PTProvo Cirrus LLC · Provo, UTN403RMUlpiano Amy L · Carolina, PRN403SWheeler James · Shreveport, LAN403SACalk Mark C · Troy, ALN4043GGalaxy Aviation Services LLC · Orlando, FLN404BTMosaid Aviation LLC · Copperopolis, CAN404CPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404DGSubgup LLC · Naples, FLN404NSJ + D Aviation Services LLC · Centerville, MAN404PJPrivate Jet LLC · Miami Springs, FLN404RGJoyner James M · Eagle River, AKN404SBIntegra Equipment LLC · Payson, AZN404SGColon Aviation LLC · Greenville, SCN404TLBrock Christopher H · Roswell, GAN404WMArmbruster LLC · Amherst, OH
Back to AD 2012-10-13