AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N660BCHolland Jack R · Mc Lean, ILN660CMJj Aviation LLC · Saint Peters, MON660TMPeacock Quarry L · Post Falls, IDN661CPSouthern Aircraft Consultnacy Inc Trustee · Casper, WYN662VN662v LLC · Starkville, MSN66323Henley William A · Hillsboro, TNN66329Nelco Farms Inc · Fairfield, IAN66330Yon Joseph W Jr · Pendleton, SCN66356Noble Scott W · Fort Wayne, INN66361Walker Joy S · Concord, GAN66405Mh Aviation LLC · Foster City, CAN66580Wyatt Mary Ellen Personal Representative · Weirsdale, FLN66581Big Bend Soaring Inc · Port Orange, FLN66582Ulmer Michael L · Nolensville, TNN66583Johnson Timothy D · Chapel Hill, NCN666PLAmundson Scott E · Wrightwood, CAN668BCThompson Mark D · Edgewood, TXN669CPEmerald Isle Apartments LLC · Los Angeles, CAN669XDiehl Steven K · Homestead, FLN66CDKcsi Aerial Patrol Inc · Bakersfield, CAN66LKeating Gregory D · Carpenter, SDN66PMMajestic Air LLC · Lowell, MIN66SEDaubenberger Joseph R · Hood River, ORN66VTDaigle Cynthia · Sanford, MEN6702CDebaun Curtis A III · Terre Haute, INN6704CCook Jon · Valencia, CAN6705CSchneider James Stephen · Olympia, WAN6710CNeto Robert A · Greenwood, FLN6712CHofstetter Mike T · Saint James, MON6714CHolsclaw Ralph J · Woodland, CAN671RMKapp Florian C · Lagrange, KYN671SAKuhn Ent Inc · Manilla, INN6726NBritsch Uwe K DBA · Klamath Falls, ORN673JFHall Matthew P · Fowlerville, MIN675WMStoecklein Christine · Stanwood, WAN677ACMeister Michael S · Muscoda, WIN6789WAspiring Aviators Aero Club Inc · Winter Haven, FLN678ACHabetz Kenneth B · Ragley, LAN678DWAnderson Timothy · Pilot Rock, ORN679DBDeddens R Michael · Camarillo, CAN67BFHigh Key Aviation LLC · Windsor, VAN67KJMullahy Patrick · Burlington, IAN67LWJohenning Leon C II · Lexington, VAN67NCEastern Stearman Inc Trustee · Leesburg, VAN67NDRegistered aircraftN67SGCotton Wayne L · East Aurora, NYN680PSSweeney Jim M · Thomson, ILN68499Sheboygan Survey LLC · Waldo, WIN684ACMccabe Gurney G · Watertown, NYN68500Air Dakota Flite Inc · Hettinger, ND
Back to AD 2000-25-02 R1