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.
N46RVWithey Charles E · Hanson, MAN46SDPacific Fleet Aviation LLC · Rochester, NYN46SHMoghaddas Ali · Lake Sherwood, CAN46TESerenity Aero LLC · Cape Girardeau, MON46TFHowell George Ryan · Conway, NCN46TJLile John G · Iowa Park, TXN46TMCartledge Douglas J · Seville, OHN46UTVon Schmidt Gordon D · Waretown, NJN46VCAltitude & Anchor LLC · Kalispell, MTN46VKMoskin Jeffrey M · Culver City, CAN46VTPh Aviation Inc · Lewes, DEN46WBBullen Riley P · Kingman, AZN46WFFoy William N · Murfreesboro, TNN46WMMallia Karen W · Schenectady, NYN46WPPowers Phillip M · Cumberland Gap, TNN46YHDouglas Hiram P · Godley, TXN46YMAircraft Partner Holdings Inc Trustee · BerlinN4700FAssociated Equip Representatives Inc · Yakima, WAN4700SGiddyup Flyers LLC · Danville, CAN4701AWtfa LLC · Decatur, ALN4701DMiller Larry L · Dade City, FLN4701KMorgan Carl A · Mayhill, NMN4701LTrainor Jonathan P · Bridgewater, NJN4701QWindsor Greg A · Anchorage, AKN4701SBailey Mark E · Owingsville, KYN4701URegistered aircraftN47023Morey John Jack · Port Orange, FLN4702FSouthern Aces LLC · Geneva, FLN4702HAbove All Others Consulting Inc · West Palm Beach, FLN4702KUniversity Auto Sales Inc · Pell City, ALN4702MVolant Aviation LLC · Brenham, TXN4702QDriggs Daniel H · Anchorage, AKN4702VBrown Anthony · Pacoima, CAN4703AStromberg Gary J · Medicine Lake, MTN4703KSkeffington Robert C · Topsfield, MAN4703LMaust Luke A · Accident, MDN4703VLangham William Hb · Uvalde, TXN4704ABrown Helicopter Inc · Pensacola, FLN4704CWright Brian A · Nampa, IDN4704NScott Lester N · Pleasanton, CAFirst renewal noticeN4704PCarlson Brent · Medford, ORN4705DN4705d LLC · Oklahoma City, OKN4705KYi Ranches Lp · Reedley, CAN4705LHorton Kelly · Hollis, OKN4705NBrentco Aerial Patrol Inc · Canton, OHN4705PHam Edward E · Boring, ORN4705UIverson James P · Soldotna, AKN4706BCollegiate Peaks Aviation LLC · Salida, CON4706DKelly William W · Springfield, ORN4706KWitman Michael R · Milliken, CO
Back to AD 2007-04-19 R1