AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N65742Mustang Sally Aviation LLC · Camden, SCN65743University Of Central Missouri · Warrensburg, MON65745Mustang Sally Aviation LLC · Camden, SCN65746Son Cameron D · Groveland, FLFirst renewal noticeN6574DFly Carolina LLC · Concord, NCN6574EGoodman Bert D · Canaan, MEN6574GPplforu LLC · Fort Worth, TXN6574TSan Diego Community College District · San Diego, CAN65750Christiansen Aviation LLC · Wilmington, DEN65752Owens Flight Training LLC · Lafayette, LAN65753Flying Bulldogs LLC · Joplin, MON65758American Patrols Inc · Midland, TXN6575AWhitmore Alex · Terlingua, TXN6575EPoutre Robert P · Osceola, WIN6575FBarnett Joe N · Siloam Springs, ARN6575TSetzer Theodore E · Granite Falls, WAN65767Chu'S Sky LLC · Brandon, FLN6576NFaaz Aircrafts LLC · Irving, TXN6576TShields Aidan J · Soldotna, AKN6576XG23 Holdings LLC · Hollywood, FLN65770Thompson Clinton J · Greer, SCN65772Sky Adventure LLC · Bartlett, TNN65773Ial Corp · Lewes, DEN65775Ristrim Eric · Henderson, NVN65776Meridian Aviation Holding Company · Teterboro, NJN6577ANafus Gifford William · Palmer, AKN6577HRegistered aircraftN6577RAir Echo Alpha 51 LLC · Erie, CON6577TRegistration Pending · Milton, DERegistration pendingN65784Ohio State University · Columbus, OHN65789Burket George C · North Hollywood, CAN65790Horan Peter · North Easton, MAN65795Bank Of Utah Trustee · Salt Lake City, UTN65798Samons David M · Phoenix, AZN6579ESkinner William T III · Little Rock, ARN6579FPratka Rhett A · Pleasanton, TXN657CPCivil Air Patrol · Maxwell Afb, ALN657EREmbry-Riddle Aeronautical University · Prescott, AZN657SCKruse Shannon E · Republic, MON657SPChristiansen Aviation LLC · Wilmington, DEN657SRRm & Lp Ltd · Azalea, ORN657TPZma LLC · North Little Rock, ARN6580AHelleloid Kristen L · Intl Falls, MNN6580EReady Aim Flyer LLC · New Castle, DEN6580FLawson Jeremiah · Lunenburg, VTN6580GMonskey David Paul · Minnetonka, MNN6580TOlson Kenneth L · Raymond, WAN65813Northwest Wings LLC · Hillsboro, ORN65815Montgomery David A · Mancelona, MIN6581GCox Martin S · Greenwood, IN
Back to AD 79-10-14 R1