AD 67-22-01
Registered aircraft · 135
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:67-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:67-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:67-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:67-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.
N411FSRomain Bevin G · St Thomas, VIN411JFCentral Airlines Inc · Overland Park, KSN411WRForbes Greg · Placerville, CAN415BHCentral Airlines Inc · Overland Park, KSN41KVRockberry LLC · Wilmington, DEN443WACentral Airlines Inc · Overland Park, KSN444BDAddington James T · Denton, TXN444CACentral Airlines Inc · Leawood, KSN444CBCentral Airlines Inc · Overland Park, KSN444WAWiseman Aviation Inc · Flagstaff, AZN458PAFuller James Andrew · St JohnN471DAero Food Imports LLC · Dover, DEN500FTTwin Aviation LLC · Coushatta, LAN500GWFeldtman Enterprises Inc · Wilmington, DEN500TUAlpha Jets USA Inc · Clarksville, TXN501TCCourtney Aviation LLC · Columbia, CAN5035ESuburban Air Express Inc · Fairbanks, AKN516DTCentral Airlines Inc · Overland Park, KSN520DRDmgf LLC · Bertram, TXN523ATCentral Airlines Inc · Overland Park, KSN526RJN526rj LLC · Sulphur, OKN526VRR V Aviation LLC · Thatcher, AZN543CBTwin Aviation LLC · Coushatta, LAN55BZDead Ant Aviation LLC · Wilmington, DEN572TNShelton Paul K · Flushing, NYN6106XAir Margarita Inc · San Juan, PRN610BWCentral Airlines Inc · Leawood, KSN6114XHardy Gareth R · Thatcher, AZN611DWNav Solutions LLC · Lewes, DEN6127XSalinas Manuel · Lamesa, TXN6136XGo Leasing Company · Phillipsburg, KSN6157XBluesky Geospatial Ltd · North Adams, MAN6164XRandall Kyle T · Klamath Falls, ORN6212XCummins Donald · Natchitoches, LAN6215XWeber Donald E · Saint David, AZN6224XN6224x LLC · Lake Havasu City, AZN6226DNielsen James R · Carson City, NVN6253XMoudy James D · Fairhope, ALN6258XJ & S Aviation LLC · Fairview, OKN6266XWells & West Inc · Murphy, NCN6272XPrairie Aviation Museum Inc · Bloomington, ILN6287XWallen Joe · Knoxville, TNN6290XDelcor Electronics Inc · Mount Vernon, NYN6296XDye Michael M · Bastrop, TXN62LLAirborne Research LLC · Fort Pierce, FLN630KCCentral Airlines Inc · Leawood, KSN630TAN630ta Corp · Miami, FLN6350UWeatherbird Ltd · New York, NYRegistration revokedN6369USpecialty Aero Services LLC · Bayside, WIN666KABeulah Ranch LLC · Cheyenne, WY
Back to AD 67-22-01