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.
N759MVHirneisen Natalie A · Flourtown, PAN759MWDirect North Inc · Solon, OHN759MXSchulz Roger B Trustee · Burlington, IAN759MYN759 My LLC · Reading, MAN759MZRochholz Edward · Medford, ORFirst renewal noticeN759NASteffora Philip T · Hollister, CAN759NBClerget Joseph B · Bonney Lake, WAN759NCRegistered aircraftN759NDNelson Donald O · Eureka, CAN759NFN759nf LLC · Wilmington, DEN759NGWackman Ranch · Elk Grove, CAN759NJBlair Aircraft No 1 LLC · Salt Lake City, UTN759NLGolden Thaddeus · Myrtle Beach, SCN759NRNugent Patrick L · Keller, TXN759NSAnsorge Inc · Elk Grove, CAN759NZMassa John · Fayetteville, GAN759PCFrihed LLC · West Yellowstone, MTN759PDEmd Enterprises LLC · Lafayette, LAFirst renewal noticeN759PERay James · Twin Falls, IDN759PHKriss Richard Co-Trustee · Poulsbo, WAN759PJBoyaire Inc · Harvest, ALN759PKIberlin Ranch · Gillette, WYN759PLLewis Robert B · Lexington, VAN759PMRocereta Michael D · Eagle River, AKN759PNBrown Richard D · Shelbyville, ILN759PSKessler Steven F · Whitewater, WIN759PTSparkman Wings LLC · Greenville, SCN759QDTonya Byrd Insurance Agency Inc · Turbeville, SCN759QHKcsi Aerial Patrol Inc · Bakersfield, CAN759QLDanger Zone Aviation LLC · Mound, MNN759QNJordan Russell L · Grand Junction, CON759QTSalkantay Aviation LLC · Prosper, TXN759QYBdr Aviation LLC · Dover, DEN759QZRollins Thomas M · Salt Lake City, UTN759RAPrx Philip G · Fairbanks, AKN759RDWilliams Kenneth R · Bakersfield, CAN759RERissel Phillip R · Hillsboro, ORN759RFWiley Jason L · Eau Claire, WIN759RGWilkie Bruce · Georgtown, TXN759RMK&G Transit LLC · Fort Mc Coy, FLN759RNAshmead Thomas G · Somerset, CAN759RPSayum LLC · Gonzales, CAN759RRN759rr LLC · Franklin, TNN759RTMazur John · Port Orange, FLN759RVOklahoma Airmen Flying Club Inc · Jenks, OKN759RWLeone Frank T · Elmwood, NEN759RZWelch Ronald R · Moses Lake, WAN759STraining Planes LLC · Tampa, FLN759SGSalty Dog Aviation LLC · De Soto, MON759SKMolster Clark · Newbury Park, CA
Back to AD 79-10-14 R1