AD 75-12-07
Registered aircraft · 338
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:75-12-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-07')
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:75-12-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-07') 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.
N69657Registration Pending · Poplar Grove, ILRegistration pendingN69658Air Aller LLC · Blaine, MNN69663Speas Stephen T · Winston Salem, NCN69665Tony Flies Inc · Sparta, NCN69673Antonini Vittorio · New York, NYN69694Bas Part Sales LLC · Greeley, CON69699Three-Ten LLC · Lewes, DEN69704Donahue Paul · West Palm Beach, FLN69708South Seattle College · Seattle, WAN69723O'Brien John P · Centerville, OHN69728Sharff Steven T · Georgetown, DEN69729Eastern Florida State College · Cocoa, FLN69743Howard Richard J · Sioux Falls, SDN69744Registered aircraftN69754Elevated 7 LLC · Kalispell, MTN69797N69797 LLC · Denver, CON69831Epic Aviation Services LLC · Kemah, TXN69842D2 Aviation LLC · League City, TXN69846Billingsley Arthur B · Green Cove Springs, FLN69848Onaero Inc · Santa Monica, CAN69937Hellix LLC · Charlotte, NCN69938Stapleton John Blase · Gulf Shores, ALN69942Columbus State Community College · Columbus, OHN69951Cosper Jared L · Austin, TXN699WSGivens Byron Keith Jr · Warner Robins, GAN69HBRowe Michael J · Crest Hill, ILN711CTClinton 83 Aviation LLC · La Place, LAN711MM711mm LLC · Boerne, TXN713MFBoundless Aviation LLC · Wilmington, DEN718MAGlinn Andrew T · Keystone, NEN71WDBlach Rhino Ltd LLC · Phoenix, AZN721SJAir America Flight Center LLC · Daytona Beach, FLN7505QJohnson Michael L · Jefferson, TXN7510QOne Zero Q LLC · Mount Pleasant, MIN7512QGorge Winds Aviation Inc · Fairview, ORN7517QQuay Ventures LLC · Alto, TXN7525QBuckin Donald L · Phoenix, AZN7526QWhat A Day To Travel LLC · Edgerton, WIN7531QSantiago Jose G Jr · Woodstock, GAN7537QRegistration Pending · Defiance, OHRegistration pending, pending cancellationN7552QTaylor Randy L · Upland, CAN7554QSky Farmer LLC · Culleoka, TNN7564QFairchild Chad E · Logandale, NVN7568QJughead Aircraft LLC · Salina, KSN7586QTyler Rdh Investments LLC · Tyler, TXN7589QTemptation Motors Ltd · Hayward, CAN758DCSale Reported · Altoona, FLSale reportedN7600QTwin D LLC · Lake City, FLN7602QKbg Air LLC · Deerfield Beach, FLN7626QSnap Roll Enterprises LLC · West Chester, OH
Back to AD 75-12-07