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.
N444VHMf Helicopters LLC · East Troy, WIN444VPBalzer Joseph W · Sevierville, TNN444VWN444vw LLC · Union Gap, WAN444WAWiseman Aviation Inc · Flagstaff, AZN444WELiberty Steaks LLC · Latham, NYN444WRNuccio Jeffrey W Trustee · Signal Mountain, TNN444XSmart Visual Systems LLC · Georgetown, TXN444XPEiron Nadav · Portola Valley, CAN444YTHelseth Craig S · Fort Pierce, FLN444ZATubb Jeffrey Scott · Farmington, NMN444ZFFrazier Jon A · Vista, CAN444ZZEmerald City Aircraft Leasing Inc · Port Orchard, WAN44500Vinant-Tang Gary · Playa Del Rey, CAN44502Kartman Dennis J · Verona, WIFirst renewal noticeN44505Pilgrim John B · Pearland, TXN44507Bebout Stuart Lee · Chapmansboro, TNN44509Central Washington University · Ellensburg, WAN4450ABraxling Todd A · Soldotna, AKN4450JBao Yucai · Andover, KSN4450TMatt Houchin Holdings LLC · Middletown, OHN4450WVarnell Chad W · Dripping Springs, TXN44511Sevier County Choppers Inc · Sevierville, TNN44512Almond Wayne · Edgewater, FLN44514Taylor Clarence J · Pipestone, MNN44518Jsp Aviation LLC · Wauconda, ILN44519Schroeder Craig L · Tipton, IAN4451ALee Donald R · Talkeetna, AKN4451PUpper Apache LLC · Titusville, FLN4451SCaporale Ron · Dillon, MTN4451WFlying On Edge LLC · Redmond, WAN4451ZSwannack Peter J · Lamont, WAN44521Silker Services LLC · Schaumburg, ILN44524Cosklo Scott C · Clifford Township, PAN44525Registered aircraftN44526Charles City Aeronautics Inc · Charles City, IAN44528Flywerx LLC · Anchor Point, AKN4452HMick Hill Enterprises · Cedarpines Park, CAN4452JFly Around Alaska LLC · Palmer, AKN4452PAviation Business Corporation · Saint Louis, MON4452RZitting Fredrick J · Colorado City, AZN4452TUtehin Nick A · San Mateo, CAN4452WHubbard Mark A · Wilmington, DEN4452XAlpha Dairy Chi LLC · Locust Grove, OKN4452ZMutch Max Samuel · Anchorage, AKN44530Wycoff Ryan · Watauga, TXN44534Sale Reported · Keystone Heights, FLSale reported, pending cancellationN44536Dickamore Chris E · Lewiston, IDN44537Majoka Hasham A · Southwick, MAN44538Berkshire Aviation Enterprises LLC · Great Barrington, MAN4453ANau Evan D · Manchester, MI
Back to AD 2007-04-19 R1