AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N555KGLegacy Performance Inc · Wilmington, DEN555KLShemenski Aaron J · Tiverton, RIN555KMVerrill Christopher R · Williamstown, NJN555KSKlotz Aviation LLC · Holcomb, KSN555LASouth Latitude Aviation Service LLC · Humble, TXN555LBDeuling Jarrett R · Lexington, KYN555LFMadden Todd A · Houston, TXN555LMGrey Sky LLC · Bossier City, LAN555LTHogan Daniel · Salina, KSN555MAAlexander Mary B · Gig Harbor, WAN555MGHampshire Blue Skies LLC · Bedford, NHN555MJMarker Michael M Jr · Los Lunas, NMN555MLSchramkowski Paul · Brentwood, TNN555MMRelativity Inc · Lakeway, TXN555MNThomas David R · Apex, NCN555MPMiller Gregory Trustee · Anchorage, AKN555NAWe Warrior Three LLC · Paragould, ARN555NGPattillo Jon S · Spotsylvania, VAN555NSN8241r LLC · Leawood, KSN555PManson Howard William · Pinckney, MIN555PAPyle Dana C · Naples, FLN555PBM5 LLC · Kit Carson, CON555PDSw Plains Aviation LLC · Ford, KSN555PUSkyborne Airline Academy Inc · Vero Beach, FLN555PXWindsock Holdings LLC · Amarillo, TXN555PZLada Aviation LLC · Alpine, UTN555QFColumbia Asset Trust Corp Trustee · Wichita, KSN555QRCarry On Leasing Inc · Wilmington, DEN555RAMooseknuckle Aviation LLC · Haslet, TXN555RCCaron Robert M · Fort Pierce, FLN555RLBorek Thomas J · Homestead, FLN555RMCulwell Lewis D · Helena, MTN555RPGreenwood Auto LLC · Itta Bena, MSN555RSR&M Aviation LLC · Austell, GAN555RWSkyrunner Charters LLC · Colleyville, TXN555RYA-1 Windshield Inc · Rexburg, IDN555SCBlack Raven LLC · Monroe, LAN555SKJld Resources Management LLC · Helena, MTN555SLHuffman Jacob M III · Burleson, TXN555SMWalla Walla University · College Place, WAN555SNMohave Maverick Aviation LLC · Bullhead City, AZN555SPJohnston Thomas · Austin, TXN555SWAtlantic Resources Of Miami Inc · Deland, FLN555TGDodson International Parts Inc · Rantoul, KSN555TJRegistered aircraftN555TMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLN555TSBas Part Sales LLC · Greeley, CON555TWMccabe Robert J Trustee · Cherry Hill, NJN555TXBoujo Yoni · Valley Village, CAN555TYKiefer Karl F · Spring, TX
Back to AD 2007-04-19 R1