AD 84-10-01 R1
Registered aircraft · 20,485
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N1676UDigicam Co · Henderson, NVN1676XSkydancer Le LLC · Wilmington, DEN1677CDavis Aero LLC · Incline Village, NVN1678XFly Guys LLC · Arcata, CAN1678ZLongmire Dale · Senoia, GAN1679XBouchereau Raymond Jr · San Dimas, CAN1679ZRiemer Emil F · Brush Prairie, WAN167LPSymanowski Kevin L · Reeder, NDN1680CRogers Terrence W · Almond, WIN1680RSchulze Roger F · Hanford, CAN1681CClark Eddie · Naknek, AKN1681UMeise Bill · Spring Green, WIN1682CFly & Fish LLC · Kalispell, MTN1682RDelcamp Don D · Troy, OHN1683ZSchmitz David K · Spooner, WIN1684CBredin William B · Anchorage, AKN1685CBallard Heather A · Pleasant Prairie, WIN1686CButts Michael D · Carson City, NVN1686ZBruegger Shannon B · Lance Creek, WYN1687XMorton Douglas E · Cody, WYN1688ZMock David J · Mesa, AZN1689MR D Offutt Co · Fargo, NDN1689ZT&R Airplane LLC · Big Lake, AKN168AERobinson Kevin B · Texarkana, TXN168CPCivil Air Patrol · Maxwell Afb, ALN168DKOtv Leasing · Greenville, DEN168DSVertx Fleet Holdings LLC · San Diego, CAN168SABruchid Snodgrass LLC · Reno, NVN168TAKj Aviation Holdings LLC · Chesterfield, MIN168TCVan Bortel Aircraft Inc · Arlington, TXN1691CSchrom Edward C · Manchester, PAN1692CVandevoorde Gary A · Davenport, IAN1693CDeardorff Dallas · Plains, MTN1693RLeap Aviation Inc · Wilmington, DEN1695CSpeed Richard · Boise, IDN1695MGc Profits Inc · Reedley, CAN1695RLehne Michael · Portland, ORN1696CCarraher Mark T · Spalding, NEN1696RMoore Alan · Glenwood, ARN1696XCenturion LLC · New Bern, NCN1698RRussell Robert Q · Genoa City, WIN1698XCmo Blue Sky LLC · Tomball, TXN1699CGrismer Jeff Trustee · Hemet, CAN1699LBorrero Marien Manuel · Carolina, PRN1699MCodner Nicholas Jr · Londonderry, NHN1699RMacdonald Eric J · Belleville, MIN1699ZSkopec David P · Bend, ORN169CPCivil Air Patrol · Maxwell Afb, ALN169DPAdrenaline Inc · Chambersburg, PAN169FTHolmstrom Darrell D Trustee · Anchorage, AK
Back to AD 84-10-01 R1