AD 94-04-13
Registered aircraft · 274
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:94-04-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:94-04-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:94-04-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:94-04-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.
N411VVScott William H · Mount Pleasant, SCN411WRForbes Greg · Placerville, CAN4131BPadgett Mfg Inc · Bradenton, FLN4136BWright Michael E · Hurricane, UTN4142BKnutson Wayne R · Tioga, NDN415BHCentral Airlines Inc · Overland Park, KSN4179BMitchell Matthew K · Cushing, OKN4189BKruger Thomas H · Hoquiam, WAN41KVRockberry LLC · Wilmington, DEN424RKTerry Ryan · White Lake, MIN4278SChagnot Catherine J · Athens, OHN42MSPlukair Texas LLC · Houston, TXN42NZCo Fire Aviation Leasing Inc · Fort Morgan, CON443WACentral Airlines Inc · Overland Park, KSN444BDAddington James T · Denton, TXN444CACentral Airlines Inc · Leawood, KSN444CBCentral Airlines Inc · Overland Park, KSN444TSUig Transport LLC · Raleigh, NCN444WAWiseman Aviation Inc · Flagstaff, AZN458PAFuller James Andrew · St JohnN4618ESale Reported · El Paso, TXSale reportedN4622EMontana Department Of Highways · Helena, MTN471DAero Food Imports LLC · Dover, DEN47ACReabe Aircraft Improvement Inc · De Pere, WIN4QSPonderosa Aviation LLC · Safford, AZN500FTTwin Aviation LLC · Coushatta, LAN500GWFeldtman Enterprises Inc · Wilmington, DEN500HMTalos Aviation Group LLC · Blackstone, VAN500RXGiesler Gary J · Hermann, MOFirst renewal noticeN500SJAir Data Solutions LLC · Natchitoches, LAN500TUAlpha Jets USA Inc · Clarksville, TXN500VEGame On Aviation LLC · Charlotte, NCN501TCCourtney Aviation LLC · Columbia, CAN5035ESuburban Air Express Inc · Fairbanks, AKN503RTPew Don E · Queen Creek, AZN507JPShrike Comm LLC · Matthews, NCN512JDOntrac Air Service Inc · Springfield, ORN516DTCentral Airlines Inc · Overland Park, KSN519WATropeano Construction Inc · Belleview, FLN520DRDmgf LLC · Bertram, TXN520RNAeronorth LLC · Ann Arbor, MIFirst renewal noticeN523ATCentral Airlines Inc · Overland Park, KSN526RJN526rj LLC · Sulphur, OKN526VRR V Aviation LLC · Thatcher, AZN526WYSteelesky Ltd · Maineville, OHN531SASpur Aviation Services Lc · Twin Falls, IDN532SA2flyshrike LLC · Miramar, FLN533SASpur Aviation Services Lc · Twin Falls, IDN534SASpur Aviation Services Lc · Twin Falls, IDN536SAMx Leader LLC · Monterey, CA
Back to AD 94-04-13