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.
N321VESullivan Mike D · Braddyville, IAN321VTWinick Scott · Jay, VTN321WFWings Over Texas Holdings LLC · Denton, TXN321WHBonanza Equipment Leasing LLC · Missoula, MTN321WMMartinez Jose A · Orlando, FLN321WPRadmall LLC · Commerce City, CON321WRFord Paul · Princeton, NJN321WSWrong Brothers Aviation LLC · Wilmington, DEN321WVHill Stephen D · Lincoln, NEN321WYWhitescarver Suzanne L Trustee · Las Vegas, NVN321XVerrall Charles Peter Jr · Florence, AZN321YZStroh Michael · Killdeer, NDN32200Owsley Kevin · Auburn, ALN32204Flying Country Club Inc · Coal Valley, ILN32206Williams Jonathan · Meadow, TXN32209Mitchellville Flyers Inc · Annapolis, MDN3220JFagen Inc · Granite Falls, MNN3220WBarnes Matthew Thomas · Valdosta, GAN3220YTanner Fred E · Westville, FLN3221SPropwash LLC · Mesquite, NVN3221WRay Troy D · Roanoke, VAFirst renewal noticeN3221YRegistration Pending · Brea, CARegistration pendingN32223Boehm William Dean · Baldwin, ILN32228Segalla Susan B Trustee · Venice, FLN3222DBeggs Patrick C · Salem, ORN3222PAmlz Air LLC · Rockville, MDN3222UMilpower Inc · Nampa, IDN3222YCreighton Andrew M · Lebanon, TNN3222ZBoggs Anthony M · Pringle, SDN3223BTechmur LLC · Loudonville, NYN3223DCliff Robinson Real Estate Corp · Madison, INN3223PPrestige Tech Consulting Inc · Carrollton, TXN3223TRuano Edwin B · Phoenix, AZN3223UPerry Joseph R · Portland, ORN32245Johnson Donald D · Scottsdale, AZN3224CHassebrock John M · Colorado Springs, CON3224FShaffer Aviation LLC · Keystone Heights, FLN3224PEighttwotwo LLC · Wilmington, DEN3224QRech Jack R · Mohave Valley, AZN3224SSkylane Trio Ltd · La Junta, CON3224WMedic Choppers LLC · Springdale, ARN3224YCrouchet Jay · Kremlin, MTN3224ZBagley Sherell G · Suwanee, GAN32251Kful Flyers Foudation Inc · Fullerton, CAN32255Registered aircraftN32256Hasek Christopher A · Plano, TXN32258Wing Rentals LLC · Phoenix, AZN3225KWjm Aviation LLC · Friendswood, TXN3225RHansen Duane D · Rockford, ILN3225UBlizzard Air LLC · Midland, TX
Back to AD 2007-04-19 R1