AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N41229Whitewings Inc · Lewis Center, OHN4122DCloud Chaser Aviation LLC · Chesnee, SCN4122HBeck Randy R · Claremont, CAN4122JCollum Aviation LLC · Milton, FLN4122KWargo Michael S · Colorado Springs, CON4122QV V S Implements LLC · Wilmington, DEN4122YPetter David · Stuttgart, ARN41230Heller Ross S · Gig Harbor, WAN41236Van Wagner Aerial Media LLC · Hollywood, FLN4123EDomke Victoria · Fairbanks, AKN4123JHebrank Kenneth A · Greensburg, PAN4123UCavu Air Holdings Inc · Dover, DEN4123ZOne2one LLC · Westminster, CAN41241N84dt LLC · Missoula, MTN41243Collette Cameron Hayes · Tuscaloosa, ALN41249Sale Reported · Nephi, UTSale reportedN4124DAshcraft Matthew · Abbott, TXFirst renewal noticeN4124EFuoss David J · Draper, SDN4124HTyler Patrick E · Poplar Grove, ILN4124JRiggin Flight Service Inc · Madison, SDN4124MN4124m LLC · Richfield, OHN4124N2c Air LLC · Edmond, OKN4124SAvondale Aviation LLC · Park Ridge, ILN4124VFlyry Aviation LLC · Mahwah, NJN4124WGeaux Automotive Advertising LLC · La Place, LAN4124YConsolidated Aviation Services LLC · Seymour, TNN4124ZAustin Kyle · Havre, MTN41259Pan Am Flight Services - St Joseph LLC · Saint Joseph, MON4125DSrq Framing LLC · Sarasota, FLN4125GSeeding Operations And Atmospheric Research (Soar) · San Angelo, TXN4125HOsterbeck Jeffrey A · Jackson, WIN4125JYero Miguel A III · Santa Ana, CAN4125KFiji Air LLC · Atlanta, GAN4125TSummerskyz Inc · Saint Joseph, ILN4125VMyhrstad Thor · Aptos, CAN4125XRedlion Asset Recovery LLC · Port Saint Lucie, FLN4125ZJordan David Thomas · Anchorage, AKN41262Sholley Michael R · Long Beach, CAN41264Cedar County Flying Club Inc · Tipton, IAN41265Sunrise Aviation Y1n LLC · Albert Lea, MNN41267Faulkner Terry · Dixon, CAN4126ANovember Alpha LLC · Dover, DEN4126JRogers Barclay L · Martinsburg, WVN4126PPorebski Peter T · New Port Richey, FLN4126SAv Advantage LLC · Birmingham, MIN4126UInter American University Of Puerto Rico · Bayamon, PRN4126XTreat Michael F · Webster, WIN41271Paris Keely Owen · Ottumwa, IAN41279Paratus Air DBA · Auburn, INN4127ALiquid Metal LLC · Wilmington, DE
Back to AD 2007-04-19 R1