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.
N35031Granite Bay Properties LLC · Nicholasville, KYN35032Galten Banning D · Willits, CAN35033Aero Pilots Inc · Norman, OKN35034Prime Michael F · Enumclaw, WAN35036Alpha Kilo Aviation LLC · Oxford, MDN3503KRunyon Michael · Charlotte, NCN3503YNorthern Lights Renewables LLC · Condon, MTN3503ZMcmath Don · Collinsville, OKN35041Black Alan D H · Mariposa, CAN35044Slo Flight LLC · San Luis Obispo, CAN35047Leps Jeffrey W · Frisco, NCN3504FBraden Peter S · Elizabethtown, KYN3504PWingsleasing LLC · Wichita, KSN3504YThigpen Alec DBA · Spanish Fort, ALN3504ZHeadrick John E · Eolia, MON35050Wings Aloft LLC · Pierre, SDN35053Tj Flight LLC · Cypress, TXN35056Walters Craig S · Lake City, FLN3505FWade Bradley S · Waterman, ILN3505MMountain Green Aviation LLC · Morgan, UTN3505TAa-Aero Inc · Fairfield, NJN3505XSiegel Craig A · Tucson, AZN35061Delucia Dennis DBA · Franklin, PAExpired dealer, pending cancellationN35063Purdue Aviation LLC · West Lafayette, INN35065Newman Richard T · Seattle, WAN35068Monroe Robert S · Oceanside, CAN35069Duffek John C · Hillsborough, NJN3506GDelta State University · Cleveland, MSN3506QEjair LLC · Shelburne, VTN3506TBaron Logistics LLC · Metairie, LAN3506XBevers David A · Colfax, CAN35074Nanny Stephen D · Eagar, AZN35076Bishop William M · Rougemont, NCN35077Carreno Victor A · Guaynabo, PRN35079Wings Over Texas Holdings LLC · Denton, TXN3507FAerial Oklahoma LLC · Oklahoma City, OKN3507YAyers Curtis W · Greenback, TNN3507ZLaw T Wayne · West Point, UTN35083J3 Enterprises LLC · Colquitt, GAN35086Robison David P · Spencer, IAN35088Apple Jeffrey G · Sheridan, INN35089Caldwell Enterprise Inc · Grand Prairie, ILN3508FStephen G Dill Dvm LLC · Remington, VAN3508KTurnquest Alexis A · West Valley City, UTN3508PJones Casey A · Princeton, KSN3508XPietrs Robert A · Madison, ALN3509Voigt Lauren · Jber, AKN35091Kinard Taylor Layne · Collierville, TNN35092Iasco Flight Training Inc · Redding, CAN35093Staples Clint B · Nemo, TX
Back to AD 2007-04-19 R1