AD 72-01-07
Registered aircraft · 1,150
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:72-01-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:72-01-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:72-01-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:72-01-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.
N1451Shaughnessy Thomas E · Seabrook, NHN1456CBrewer Alfred D · Hillsboro, ORN1458CKohlhase Kent E · Anchorage, AKN145CSchmitt Mark R · Rockford, MIN1460CMaki Tim J · Hibbing, MNN1466CBent James L Jr DBA · Palatine Bridge, NYN1467CWeflen Arvid W · Fairbanks, AKN146THanson Brady W · Soldotna, AKN1470CHillestad Darrell L · Aberdeen, SDN1471CNorris Cathy J · Statesville, NCN1473CGo Aviation Inc · Potsdam, NYN1474CSweeney Brett D · Anchorage, AKN1476CAsher Debra L · Wasilla, AKN147TScrobola James M · Wyoming, PAN148TRegistered aircraftN1493CH G Klug Sons Inc · Omaha, NEN1500JBent James L Jr DBA · Palatine Bridge, NYN1500PBent James L Jr DBA · Palatine Bridge, NYN150CWCleveland William L · Lander, WYN150TTowe Lannie K · Madison, ALN1532VSutton Aviation LLC · Maunaloa, HIN154TKornchuk Kurt C · Wasilla, AKN1551PPhillips Kris D · Cordova, AKN1552PErickson James M · Wasilla, AKN1554PPerkins Michael D Trustee · Bigfork, MTN15558Nighthawk Air Systems Inc · Marion, TXN1557PVlasic Steven Robert · Homer, AKN1559PSnatchaday LLC · Carabaset Vly, MEN1560PGoodnight James J · Salisbury, NCN1563PShoemaker Tia M · Wasilla, AKN1565PPott David F · Fairbanks, AKN156TSale Reported · Casselton, NDSale reported, canceledN157TMccray B F Jr · Manchester, OKN1580PBltyhe Anne T · Paso Robles, CAN1588PWar Eagles Air Museum · Santa Teresa, NMN1590PForgey Carl · Petersburg, AKN1592PFerguson Robert C · Cornelia, GAN1596PPassmore Aviation LLC · Claremore, OKN1597PStokes Letta J · Chugiak, AKN1599PSnowden Robert W · Mason, TXN159TGumley Titus G · Wasilla, AKN15XXDalks Leasing Inc · Wilmington, DEN1602ABent James L Jr DBA · Palatine Bridge, NYN1604AFredericks Elmo J · Mandaree, NDN160CWAbraham Elizabeth J · Browntown, WIN1610ABauder Robert J · Soldotna, AKN1611AJones William Ransom · Anchorage, AKN1611CNorthern Flyway LLC · Anchorage, AKN1612AGlover Thomas B · Marana, AZN1620ABeaver David W Trustee · Wasilla, AK
Back to AD 72-01-07