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.
N4869JDls Aviation LLC · Gilmer, TXN4869NBlack Hawk Brothers LLC · Lakeland, FLN486ACSoaring Soul LLC · Brainerd, MNN486AKDeckload Aviation LLC · Kodiak, AKN486BLBlue Line Aviation LLC · Smithfield, NCN486CACivil Air Patrol · Maxwell Afb, ALN486CBCalifornia Baptist University · Riverside, CAN486CPCivil Air Patrol · Montgomery, ALN486DCStephens Dana M · Coxs Creek, KYN486DMMoes Sarah J · Rossford, OHN486EMMason Edward R Trustee · Wilsonville, ORN486FLBaker Donnie · Christiana, TNN486HPSlipstream Aviation LLC · La Crosse, WIN486JWWade James M · Calhoun City, MSN486KWilliams Lawrence J II · Tucson, AZN486MAOrange Wing Aviation Inc · Wilmington, DEN486MHMh Group LLC · Duncan, OKN486MMN486mm LLC · Winter Haven, FLN486PRichardson Joshua R · Mobile, ALN486PARegistered aircraftN486TCMonte D Burke · Dallas, TXN4870CHoffman Bertha M · Bethel, AKN4870DSherman Hess M · Poplar Grove, ILN4870GCal Aggie Flying Farmers Inc · Davis, CAN4870LWinyah Aviation LLC · Georgetown, SCN4870TBailey Charles G · Phoenix, MDN4870UUniversity Of Oklahoma · Norman, OKN4871BMeise Fred Walter · Moses Lake, WAN4871CFalvey Paul J · Edgartown, MAN4871FFry Robert S Jr · Poplar Grove, ILN4871JGray Robert R · Granbury, TXN4871RWagner James M · Le Sueur, MNN4871SLaingkids LLC · Lewes, DEN4871VBt Aero Precission Flight Accademy LLC · Oakdale, CAN4872AIdaho Wool Growers Assn · Boise, IDFirst renewal noticeN4872DPs N4872d LLC · Green Bay, WIN4872HPassanante John L · Newtown, PAN4872JAm Aviation LLC · Edmonds, WAN4872KMike Papa LLC · Newton, KSN4872LMartin Marvin J · Conrath, WIN4872UBushwackers Leasing LLC · Calera, OKN4873APapp Jacob R · Fort Edward, NYN4873DRagan Matthew T · Boulder City, NVN4873FFirebrand Nation · Knoxville, TNN4873G4873g Flying Club Inc · Punxsutawney, PAN4873LBaker Justin · Titusville, FLN4873RCavu Clearing LLC · Center Harbor, NHN4873SBurke Mark S · Kindred, NDN4873YCherry Hill Aviation Inc · Freetown, INN4874Goin Jeff Trustee · Polk City, FL
Back to AD 2007-04-19 R1