AD 94-05-05 R1
Registered aircraft · 26,232
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-05-05-R1')
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-05-05-R1')
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-05-05-R1') 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-05-05-R1') 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.
N6446HRogers Twyla M · Windham, MEN6446TRegistered aircraftN6447ELockwood Robert C Jr · Greenwell Springs, LAN6447GVan Holten Robert W · Flemington, NJN6448ELincoln Land Community College · Springfield, ILN6448GBradley Gilbert K · Sun Prairie, WIN6449EShamburek Steven J · Anchorage, AKN6449GAlbania Emad R · Huntingtown, MDN644JWRedding Nicholas A · Skiatook, OKN644MPPasztalaniec Matthew S · Monterey, CAN6450TEllis Samuel F Jr · Copperas Cove, TXN64518Merren Edward T · Wasilla, AKN6451BWalker Robert C · Bend, ORN6451CAgaliotis Paul E · San Martin, CAN6451EBernaldt Lyndall W · Bartlesville, OKN6451THall Martha A · Borrego Springs, CAN6452ESorenson Farms Of Montana · Forsyth, MTN6452FRobinson Bruce · Salinas, CAN6452TLeopardi Holly F · Albuquerque, NMN6453BHewitt Alan E · Renton, WAN6453EMeeks William M III · Tulsa, OKN6453GBegley Scott R · Fairbanks, AKN6454ERegistration Pending · Downey, CARegistration pendingN6454KFlying Aces Aero-Fleet Inc · Guyton, GAN6454SLorance Glenn E · Iola, TXN6455BLala Princy Jairaj · Deltona, FLN6455KFlying Gators Inc · Overland Park, KSN6456BVintage Trainers Inc · Wilmington, DEN6456FAmb Parnell G · Portland, NDN6456SBecker Richard Keith · Fraser, MIN64573Airpower Museum Inc · Ottumwa, IAN6457ENewell Michael S · Marion, OHN6457FPepper Christopher W · Memphis, TXN6457GN19752 LLC · Toledo, WAN6457KWysong Henry D III · Kent, WAN6458BChavez Lauren K Hollingsworth · Albuquerque, NMN6458FLejcar Matthew J · Mesa, AZN6458HSnead John S · Crescent City, FLN6459HMckee Thomas E · Terra Alta, WVN6459TRohlman Aaron · Republic, MON645EDDoughty John Edward · Earlville, ILN6460BSchmick Kenneth R · Fond Du Lac, WIN6460EHooks Herbert D · Templeton, PAN6460FThorton Rod W · Barrington, RIN6461GDrewry James D · Scottsboro, ALN6462SRoss Mitchell B · Ledyard, CTN6462TAdkins George E · Brooklyn, IAN6463TKemmerling Lawrence W · Mazama, WAN6464BResicum International LLC DBA · Gulf Shores, ALN6464EGeerlings Hillside Farms LLC · Holland, MI
Back to AD 94-05-05 R1