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.
N3861QLopez Mario J · Torrance, CAN3861WMendez Fidel Serrano · San Sebastian, PRN3861YMiller Todd D · Fort Wayne, INN38628Maxair Inc · Coxs Creek, KYN38629Red Tail Scholarship Foundation · Tuskegee, ALN3862DReady Aim Flyer LLC · New Castle, DEN3862GRenfro Michael W · Bethel, AKN3862KNeihart Randy L · Fontana, CAN3862MN3862m LLC · Provo, UTN3862PBrown Travis Trustee · Columbia, MON3862QQ Flyers LLC · Anaheim, CAN3862RToco Inc · Healdsburg, CAN3862THanson John M · Wht Sphr Spgs, MTN3862ZAdams Bob L · Eagle River, AKN38632Tappan Michael L · Miamisburg, OHN3863DDulley Tony A · Nine Mile Falls, WAN3863QCondor Air LLC · Pleasant Valley, NYN3864CPearce Robert W · Santa Fe, NMN3864MAscent Aviation LLC · Van Nuys, CAN3864NScherffius Steven H · Louisville, KYN3864QEvans James · Tuolumne, CAN3864TPatton Aviation LLC · Billings, MTN3864UInterrail Power Inc · Jacksonville, FLN3864ZHorizon Transportation And Rentals LLC · Phoenix, AZN38650Sciorrotta Samuel C Jr · Gainesville, GAN38656Allen James R · Olympia, WAN38657W I F A (Washington International Flight Acad) LLC · Gaithersburg, MDN3865QAmerican Patrols Inc · Midland, TXN3865WWestenberger David L · Indianapolis, INN3866ARare Aircraft Ltd · Faribault, MNN3866CProfessional Pilots Inc · Lowell, INN3866PWateractive43 LLC · Auburn, CAN3866QOcala Aviation Services Inc · Ocala, FLN3866RDurgin William W · Waquoit, MAN3866TVacracos James L · Saint John, INN3866WN3866w LLC · Broken Arrow, OKN3866YMessina Jacob · Copley, OHN3866ZForestry Aero LLC · Norwood, LAN38674Tse Aircraft LLC · Jacksonville, FLN38677Bass Michael L · Mount Olive, NCN3867CKrmo Aviation LLC · Duluth, MNFirst renewal noticeN3867DPrestige Air Worldwide LLC · Seneca, SCN3867GW & S Aviation LLC · Fountain Inn, SCN3867QLangner Dale R · Louisburg, KSN3867TSater Travis D · Salem, ORN3867WN3867w LLC · Clemson, SCN3867YGallagher Robert B · Rio Oso, CAN3867ZGaller Frank G · Elysian, MNN3868DRegistered aircraftN3868QLibbys Sporting Camps Inc · Chapman, ME
Back to AD 2007-04-19 R1