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.
N746MBTowler Brian A · Chillicothe, OHN7472BAero-Mobil Inc · Wilmington, DEN7474BBeausoleil Randy L · Livingston, TXN7477BHuey Gale R · Celeste, TXN7478BHenderson James L · Gordon, TXN747GSMidwest Thermal Optics LLC · Walnut, ILN747LWOlhughes LLC · Staplehurst, NEN747PYPrivitt Bret J · Forest Hill, TXN747SHDickson Aaron M · Arkadelphia, ARN747WMDonkers David C Trustee · Nerstrand, MNN7480BBenkert Daniel D · Rapid City, SDN7481BElstner Peter T · Prineville, ORN7485BRaab Travis C · Clinton, OKN7487BMiller Timothy J · Hutchinson, MNN7488BMorrow Larry A · Dunnellon, FLN7489BLumley John W · Boynton Beach, FLN748ACSweeet Aviation LLC · Dover, DEN7490BPeacock David W · North Bennington, VTN7492BBenson Airport Association Inc · Shoreview, MNN7493BAlwine Joshua L · Chewelah, WAN7494BBowden Terry L · Moody, TXN7496BHoldgate Frederick I · Englewood, FLN749PCGreen Hornet Aviation LLC · Washington, DCN749PJAgl Aviation And Management LLC · Payson, AZN749SKOcean Aerial Ads Inc · Berlin, MDN74CDMcburney & Associates LLC · Horseshoe Bay, TXN74NANelson Kenneth · Caledonia, WIN7500FGrindley John E · Hopewell Junction, NYN7501FStafford Tech Inc · Rehoboth, MAN7502FBarrie Lorna D · Tonawanda, NYN7503BSale Reported · Rigby, IDSale reportedN7503FPatton David · Elmendorf, TXN7504FDerr Michael K · Maitland, MON7505FIpme Management Corp · Jefferson, GAN75064Turner Steven C · Hastings, FLN75069Chappell William L · Hertford, NCN7506BDoeden Bridger J · Miles City, MTN7506FOklahoma Airmen Flying Club Inc · Jenks, OKN7507BSalzman Michael · Milford, NHN7507EBall Robert L · Clinton, OHN7507FThomson Mary Ellen · East Berlin, PAN7508BCrane Kenneth W · Oak Ridge, TNN7510FGrand Canyon Flyers LLC · Flagstaff, AZN7511FEisenbrey Glen T · Greenbank, WAN7512FCulver Marc D · Anchorage, AKN7513BWood Kent A · Holmes Beach, FLN7513ERag Wings And Radials Aircraft Leasing LLC · Georgetown, DEN7513FFrank Jerry W · Vonore, TNN7515BJeffryes Richard B · Creswell, ORN7516FMahan Phillip A · Juneau, AK
Back to AD 2000-25-02 R1