OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,560

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.

N221JBMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2023 · S/N 1212-2024N221PMHester Thomas F · Boulder, UTBuilt 2004 · S/N 451-2003N221RLittlefield Floyd E · Centre, ALBuilt 1946 · S/N 7AC-4240N2222ECowels Richard L · Plainwell, MIBuilt 1946 · S/N 7AC-5796N2226ERice James L · Mckinney, TXBuilt 1946 · S/N 7AC-5799N2227ECawley Lamb Elizabeth J · Buckley, WABuilt 1946 · S/N 7AC-5801N222CAMorse Leonard R Trustee · Cottage Grove, ORBuilt 1972 · S/N 29-72N222RKMiller Bruce · Plano, TXBuilt 1974 · S/N 448-74N222WYLeach Ron B · Bliss, IDS/N 376-72N2234PDanhauer Jeffrey · Owensboro, KYBuilt 1974 · S/N 761-74N2236EFriedrich Michael · Casa Grande, AZS/N 7AC-5810N2237EEdwards Edgar · Fort Smith, ARS/N 7AC-5811N223AJTwaddle Dennis L Jr · Nome, AKS/N 7AC5839N223GLKushner Herbert A · Bridgewater, NJBuilt 1973 · S/N 337-73N223HWChesnut Tara M · Wasilla, AKBuilt 1960 · S/N 12N223RGSale Reported · Conway, ARSale reportedBuilt 1946 · S/N 7AC-1464N2241ELefeve Douglas H · Cedar Park, TXBuilt 1946 · S/N 7AC-5815N2247ELeibenguth Ronald E · Palmerton, PABuilt 1946 · S/N 7AC-5821N224KKN224kk LLC · Newport Beach, CABuilt 2016 · S/N 1168-2016N224LBlissfield Flight Club Inc · Blissfield, MIBuilt 1945 · S/N 7AC-313N224RASierra Whiskey Aircraft LLC · Oakland, CAS/N 4832004N225ACSafeflight Alliance Inc · Osprey, FLBuilt 1996 · S/N 774-96N225QZHoward Alan L · Leeds, UTBuilt 1969 · S/N 138N225SGWilliams Stephen W · Granbury, TXBuilt 2006 · S/N 1018-2006N225THMariner John M · Houston, TXBuilt 2010 · S/N 535-2010N2261EStebbins Scott A · Elk, WAS/N 7AC-5835N2264EGauthier Peter J · Woodburn, ORBuilt 1946 · S/N 7AC-5838N2266EOtto David L · Lacey, WAS/N 7AC-5840N226BFRichmond Charles H · Denison, TXS/N 7-72N2272EGulf Airbatics Ltd · Jennings, LABuilt 1946 · S/N 7AC-5846N2274EBallou Gregg R · West Wareham, MABuilt 1946 · S/N 7AC-5848N2275EKircher Wayne E · Yorba Linda, CABuilt 1946 · S/N 7AC-5849N2277EYost David M · Applegate, CABuilt 1946 · S/N 7AC-5850N2278EBrock Harvey J · Hawthorne, FLBuilt 1946 · S/N 5852N227ACBoeger Cade Patrick · Oroville, CABuilt 1977 · S/N 335-77N227SFSager Charles K · Hedgesville, WVBuilt 2000 · S/N 437-2000N2281EMedina Angel O · Pasadena, CAS/N 7AC-5855N2287ESchober David · Union Bridge, MDS/N 7AC-5861N2288ECarlson Tatum D · Lake Bronson, MNS/N 7AC-5862N228WVarona Pedro A · Lake Placid, FLBuilt 1958 · S/N 7FC-255N2292SBall Thomas R · Westlake, ORS/N 7BCM-32N2295EDunn Allen F · Kinnelon, NJBuilt 1946 · S/N 7AC-5869N229BBKidd Clifford L · Monahans, TXBuilt 1978 · S/N 466-79N22BCSky Shark Aviation LLC · Brandon, MSBuilt 1975 · S/N 535-75N22BFAmerican Champion Aircraft Corp · Rochester, WIS/N 1390-2003N22KAHolder Jeffrey J · Madison, GABuilt 1974 · S/N 468-74N22LLKraudelt Diane I · Carthage, NCBuilt 1992 · S/N 697-92N22SXChase Jack L · Buxton, MEBuilt 2022 · S/N 626-2022N22YPEmb500 Inc · Saint Petersburg, FLBuilt 2013 · S/N 1125-2013N2300EKilo Oscar LLC · Jupiter, FLS/N 7AC-5794
Back to AD 2000-25-02 R1