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.
N731XSchorsch Kerry · New England, NDN733MWWebb Matthew · Denton, TXN736JBBrownell Kenneth C · Leverett, MAN736LRegelbrugge Marc · El Dorado, CAN737ADDe Zafra Aaron · Mill Valley, CAN73JGMeyer Gordon W · Huber Heights, OHN73PAJones Brandon B · Saint Francisville, LAN73PCMedearis Jeff W · Plevna, MTN73TDWeber Michael Scott · Gonzales, LAN73XDN73xd LLC · Houston, TXN7400BHartmann Jeffrey N · Chico, CAN7401BSherman David B · Readfield, MEN7402BRoberts Christopher J · Andover, KSN7405BDennis Rick L · Poughkeepsie, NYN7406BKraft Tyrone H · Timber Lake, SDN7407FFp Aircraft Holdings LLC · Alvord, TXN7411BWilcox Stacy S · Parker, CON7412BGonzales Donald M · Columbia Station, OHN7417BNelsonmiguel E · Lake Stevens, WAN7420BFreeman James L · Decatur, GAN7421BBrowns Valley Aviation LLC · Utica, KYN7423BSiglin Shaw D · Wellsboro, PAN7425BGreen William D · Fairbanks, AKN7426BOdlozil Henry W Sr · Ennis, TXN7427BBouton Glenn A · Kasilof, AKN7428BGrasshopper L-16 LLC · Greeley, CON7430BBugbee Frank S Jr · Schwenksville, PAN7432BSmith David C · Malott, WAN7432PWeber William A · Brodhead, WIN7433BRegistration Pending · Beebe, ARRegistration pendingN7436BLooper Kyle · Las Vegas, NVN7438BLampe Jared Joseph · Turner, MIN7439BWoyte John F · Eagle River, AKN743ACOlsson Charles E · West Point, VAN743JBLiley Brian A · Fall Branch, TNN743JFPanasuk Austin R · Sidney, MTN7440BGoethel Eric D · Hampton, NHN7447BCentral Virginia Aviation Inc · North Dinwiddie, VAN744ABBeverung Robert D · Manitowish Waters, WIN744JAWiebe Albert · Seminole, TXN744SGGimblin Robert Steven Trustee · Yuba City, CAN7451BBone Mitchell T · Calhoun, GAN7452BOesper Peter F · Taos, NMN7455BRichards Troy L · Saint Jo, TXN7456GGregory Larry C Trustee · Farmington, MON7459BSchulert Philip J · Lebanon, TNFirst renewal noticeN745LSWeaver Chris D · Hallam, NEN745MSSchamel Michael A · Salem, INN7462BKrumbine David A · Lebanon, PAN746ACCaldwell Robert I · Danville, KY
Back to AD 2000-25-02 R1