AD 75-07-02
Registered aircraft · 2,162
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-07-02')
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-07-02')
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-07-02') 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-07-02') 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.
N141JGCardinal 1jg LLC · Bakersfield, CAN1432KCovenant Physician Services Ltd · London, OHN1438CTony And Oats Great Adventure LLC · Danville, INN1442CMakelbust Michael J · Ames, IAN1454CFreespirit Ventures LLC · Bear, DEN1455CCaruso Anthony J · Southampton, NYN1479CBuilt Aviation LLC · Haymarket, VAN147MLPatton Andrew Joseph · Andrews, INN1495CGulf Coast Helicopters Inc · Pearland, TXN1498CBrutger Wayne A · Saddlebrooke, AZN1499CGalbrecht Daniel S · Arbor Vitae, WIN1521HHopkins John C Jr · Tallulah, LAN1525HKubasch Kevin M · Longville, MNN1526HThompson Roy Dayton · Bulverde, TXN1534HCooley Norbert · Elkton, MDN1535HStramer Todd Personal Representative · Hazelton, NDN1539HAve Maria LLC · Batesville, INN153AMMedford Daniel E · Lakeville, MNN1540HFurtick Reginald D · Iuka, MSN1541HAtkin Cris R · St George, UTN1542HCessna N1542h LLC · Fond Du Lac, WIN1544HBaugh Ashton C · Petal, MSN1548HShrader Brian K · Marion, INN1552HLewis Daniel Bryce · Waller, TXN1553HBuckner Robert M · Eufaula, OKN1557HOpequon LLC · Vanderbilt, PAN1559HCardair Inc · Allentown, PAN1560HFly North Of Known LLC · Aurora, ORN1561HTorpey Richard T · Bay Shore, NYN1563HSpokane Cardinal · Spokane Valley, WAN1565HSchornick Brad W · Oklahoma City, OKN1566HRohlfing Gregory C · Elmwood Park, ILN1567HKrimminger Michiel · Lancaster, SCN1568HCorner Jeremy M · Peachtree City, GAN1569HDekalb Cardinal LLC · Evanston, ILN1571HYork Ronald A · West Lafayette, INN1575HCardinal Shares Inc · Rochester, MNN1578HKramer Jason K · Longview, TXN1580HBrock Bobby Charles · New Braunfels, TXN1581HNevarrow Leon · Spring Valley, CAN1582HT G & P Enterprises LLC · Glendale, AZN1587HFowler James C · San Angelo, TXN1589HAg Scouting Solutions LLC · Huntingdon, TNN1590HWieting Roger L · Longview, TXN1593HKleinert John K · Baldwin, GAN1595HSholy Fred · Granada Hills, CAN1597HAerobox LLC · Seattle, WAN159RJBas Part Sales LLC · Greeley, CON16019Brown Kenneth D · Port Murray, NJN16021Hill Allen W · La Junta, CO
Back to AD 75-07-02